Postgres Pro
Downloads
Home   >   mailing lists

Re: backing up the data from a single table? - Mailing list pgsql-general

From Hans Schou
Subject Re: backing up the data from a single table?
Date
Msg-id CAApBw365KHmTWFdTajcYUqayCDoM-T85_di3179Ac9Y1bNd3TQ@mail.gmail.com
Whole thread Raw
In response to backing up the data from a single table?  (stan <stanb@panix.com>)
List pgsql-general
Tree view
On Fri, Sep 13, 2019 at 4:14 PM stan <stanb@panix.com> wrote:
Is there a way to "export" a single table, that can be easily re
"imported"?

Export:

pg_dump --table=foo > foo.sql

Import:

cat foo.sql | psql


pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: PG SQL and LIKE clause
Next
From: Olivier Gautherot
Date:
Subject: Re: backing up the data from a single table?