Postgres Pro
Downloads
Home   >   mailing lists

Re: [NOVICE] How extract data from pg_dump'ed files to tsv files? - Mailing list pgsql-novice

From David G. Johnston
Subject Re: [NOVICE] How extract data from pg_dump'ed files to tsv files?
Date
Msg-id CAKFQuwZfy+pV4bk4n2SnTsNBwYDyfsj13zyYfqhTLU9hSb1ovw@mail.gmail.com
Whole thread Raw
In response to [NOVICE] How extract data from pg_dump'ed files to tsv files?  (Peng Yu <pengyu.ut@gmail.com>)
List pgsql-novice
Tree view
On Tue, Oct 3, 2017 at 10:05 AM, Peng Yu <pengyu.ut@gmail.com> wrote:
Hi,

I'd like to extract the tables from the following dump to tsv files.
Does anybody know what command I should use to extract the tables into
tsv files?

​Restore the dump into an actual live database then use "COPY" or psql "\copy"

You might be able to engineering something to avoid the "restore" part but it doesn't seem worthy of effort.

David J.
​

pgsql-novice by date:

Previous
From: Peng Yu
Date:
Subject: [NOVICE] How extract data from pg_dump'ed files to tsv files?
Next
From: manno_it@libero.it
Date:
Subject: [NOVICE] The server does not listen