Home > mailing lists

Thread: Restore single table

Restore single table

From

Sonam Sharma

Date:

30 October 2019, 15:21:22

Can someone please help me with the command to restore a single table using psql.

Took the backup using below command :

pg_dump -t (tablename) dbname > tablename.sql

Re: Restore single table

From

Ritesh Jha

Date:

30 October 2019, 15:29:08

psql -d databaseName -f tablename.sql

On Wed, Oct 30, 2019, 5:51 PM Sonam Sharma <sonams1209@gmail.com> wrote:

Can someone please help me with the command to restore a single table using psql.

Took the backup using below command :
pg_dump -t (tablename) dbname > tablename.sql