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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [NOVICE] How extract data from pg_dump'ed files to tsv files?
Дата
Msg-id CAKFQuwZfy+pV4bk4n2SnTsNBwYDyfsj13zyYfqhTLU9hSb1ovw@mail.gmail.com
обсуждение исходный текст
Ответ на [NOVICE] How extract data from pg_dump'ed files to tsv files?  (Peng Yu <pengyu.ut@gmail.com>)
Список pgsql-novice
Дерево обсуждения
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 по дате отправления: