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
--- On Tue, 2/10/09, Sam Mason <sam@samason.me.uk> wrote:
From: Sam Mason <sam@samason.me.uk> Subject: Re: [GENERAL] Good Delimiter for copy command To: pgsql-general@postgresql.org Date: Tuesday, February 10, 2009, 2:41 PM
On Tue, Feb 10, 2009 at 07:07:42AM -0800, SHARMILA JOTHIRAJAH wrote: > What is a good delimiter to use for COPY command. Im trying to use > COPY command to copy data from one table to another in 2 different > databases. > Can you suggest a unique delimiter that I can use for this COPY command
Ifyou're fixed with using COPY then what about just using CSV mode?
COPY table TO STDOUT WITH CSV;
If not then why not use pg_dump?
Sam
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general