Re: Extracting data into .csv format

[Shreeyansh Dba <shreeyansh2014@xxxxxxxxx>]

On Wed, Feb 17, 2016 at 10:19 PM, Ferrell, Denise D CTR NSWCDD, H11 <denise.ferrell.ctr@xxxxxxxx> 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