Re: Good Delimiter for copy command

Поиск
Список
Период
Сортировка
От SHARMILA JOTHIRAJAH
Тема Re: Good Delimiter for copy command
Дата
Msg-id 580984.21817.qm@web110715.mail.gq1.yahoo.com
обсуждение исходный текст
Ответ на Re: Good Delimiter for copy command  (Sam Mason <sam@samason.me.uk>)
Ответы Re: Good Delimiter for copy command
Re: Good Delimiter for copy command
Re: Good Delimiter for copy command
Список pgsql-general
Дерево обсуждения
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

В списке pgsql-general по дате отправления: