| From: | Sam Mason <sam(at)samason(dot)me(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Good Delimiter for copy command |
| Date: | 2009-02-10 19:41:11 |
| Message-ID: | 20090210194111.GY3008@frubble.xen.chris-lamb.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Iñigo Barandiaran | 2009-02-10 20:14:25 | Fwd: createdb.exe and psql.exe without Promting Password |
| Previous Message | Sam Mason | 2009-02-10 19:39:15 | Re: does anyone know what to use in pg_hba.conf that will allow me to run cronjobs with pg_dump? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2009-02-10 20:06:45 | advance local xmin more aggressively |
| Previous Message | Alvaro Herrera | 2009-02-10 18:46:18 | Re: [COMMITTERS] pgsql: Update autovacuum to use reloptions instead of a system catalog, |