Postgres Pro
Downloads
Home   >   mailing lists

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

From Sam Mason
Subject Re: Good Delimiter for copy command
Date
Msg-id 20090210194111.GY3008@frubble.xen.chris-lamb.co.uk
Whole thread Raw
In response to Good Delimiter for copy command  (SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com>)
Responses Re: Good Delimiter for copy command  (SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com>)
List pgsql-general
Tree view 
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

If you'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

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: does anyone know what to use in pg_hba.conf that will allow me to run cronjobs with pg_dump?
Next
From: Iñigo Barandiaran
Date:
Subject: Fwd: createdb.exe and psql.exe without Promting Password