Postgres Pro
Downloads
Home   >   mailing lists

Re: Extracting data into .csv format - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: Extracting data into .csv format
Date
Msg-id CAGDYbUO3ZC_8+SmEL-UTpTDi6Sshq2HmUJVhBup71_z8QO7ioA@mail.gmail.com
Whole thread Raw
In response to Extracting data into .csv format  ("Ferrell, Denise D CTR NSWCDD, H11" <denise.ferrell.ctr@navy.mil>)
List pgsql-admin
Tree view
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:


 Or check below tutorial


Hope this will solve your problem.
--
Thanks & Regards,
Harshad Adalkonda
Database Administrator
www.shreeyansh.com

pgsql-admin by date:

Previous
From: Ray Stell
Date:
Subject: Re: oracle db reads from postgresql
Next
From: "drum.lucas@gmail.com"
Date:
Subject: [TIPS] Tuning PostgreSQL 9.2