Re: Extracting data into .csv format

Поиск

Список

Период

Сортировка

От	Shreeyansh Dba
Тема	Re: Extracting data into .csv format
Дата	18 февраля 2016 г. 03:27:38
Msg-id	CAGDYbUO3ZC_8+SmEL-UTpTDi6Sshq2HmUJVhBup71_z8QO7ioA@mail.gmail.com обсуждение исходный текст
Ответ на	Extracting data into .csv format ("Ferrell, Denise D CTR NSWCDD, H11" <denise.ferrell.ctr@navy.mil>)
Список	pgsql-admin

Дерево обсуждения

On Wed, Feb 17, 2016 at 10:19 PM, Ferrell, Denise D CTR NSWCDD, H11 <denise.ferrell.ctr@navy.mil> wrote:

Using PostgreSQL 9.3 on Linux

I'm trying to extract data into a comma delimited format and not having much success...seems to act totally different from Oracle. Does anyone have any suggestions?

Thank you in advance.
Denise

Hi Denise,

Please read below official documentation of copy command:

http://www.postgresql.org/docs/9.4/static/sql-copy.html

Or check below tutorial

http://www.gistutor.com/postgresqlpostgis/10-intermediate-postgresqlpostgis-tutorials/39-how-to-import-or-export-a-csv-file-using-postgresql-copy-to-and-copy-from-queries.html

Hope this will solve your problem.

--
Thanks & Regards,
Harshad Adalkonda
Database Administrator
www.shreeyansh.com

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