Re: Extracting data into .csv format

From: Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
To: "Ferrell, Denise D CTR NSWCDD, H11" <denise(dot)ferrell(dot)ctr(at)navy(dot)mil>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Extracting data into .csv format
Date: 2016-02-18 00:27:29
Message-ID: CAGDYbUO3ZC_8+SmEL-UTpTDi6Sshq2HmUJVhBup71_z8QO7ioA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message drum.lucas@gmail.com 2016-02-18 01:03:31 [TIPS] Tuning PostgreSQL 9.2
Previous Message Ray Stell 2016-02-17 22:01:23 Re: oracle db reads from postgresql