Re: How extract data from pg_dump'ed files to tsv files?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Peng Yu <pengyu(dot)ut(at)gmail(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: How extract data from pg_dump'ed files to tsv files?
Date: 2017-10-03 17:09:50
Message-ID: CAKFQuwZfy+pV4bk4n2SnTsNBwYDyfsj13zyYfqhTLU9hSb1ovw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Tue, Oct 3, 2017 at 10:05 AM, Peng Yu <pengyu(dot)ut(at)gmail(dot)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.
​

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message manno_it 2017-10-15 13:00:12 The server does not listen
Previous Message Peng Yu 2017-10-03 17:05:24 How extract data from pg_dump'ed files to tsv files?