Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Extracting data into .csv format
Date
Msg-id CAKFQuwYWWmLR4h1E2_BsTwm5POQC8J3gz-4VcJ6iyZGhGnAAYQ@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 9:49 AM, 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?

In the documentation lookup the psql "\copy" meta-command along with the SQL COPY command.​

David J.

pgsql-admin by date:

Previous
From: Stephen Tahmosh
Date:
Subject: Re: Extracting data into .csv format
Next
From: Andrea Suisani
Date:
Subject: Re: oracle db reads from postgresql