Request a Demo
Home   >   mailing lists

Re: Good Delimiter for copy command - Mailing list pgsql-general

From Andrew Gould
Subject Re: Good Delimiter for copy command
Date
Msg-id d356c5630902121315p1ab23982h5101e0aa9de8bb31@mail.gmail.com
Whole thread Raw
In response to Re: Good Delimiter for copy command  (SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com>)
Responses Re: Good Delimiter for copy command
Re: Good Delimiter for copy command
List pgsql-general
Tree view
On Thu, Feb 12, 2009 at 2:51 PM, SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com> wrote:
My data fields contains commas, tabs,'|'  etc. So I cant use t hem as delimiters..so I need a unique may be non-character to use as a delimiter...
-Sharmila


How are you backing up your data?  If your backup method deals appropriately with the characters mentioned above, then backup the data and reload them into the other tables.

If your backup method does not deal appropriately with the characters you mention, you may have larger problems on your hands.

To the list:  Does pg_dump escape characters that are the same as the delimiter?

Thanks,

Andrew

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: Good Delimiter for copy command
Next
From: SHARMILA JOTHIRAJAH
Date:
Subject: Re: Good Delimiter for copy command