How to import data from a particular table from a large postgres file?

Question

I want to import data just for particular tables in Postgres. How can I do that?

I've tried the following command. Didnt worked though.

pg_dump -U postgres -a -d -t data_pptlconfig db_name  > db_file

pg_dump is intended for export (backups). Also, the > db_file can only write to the db_file, it cannot read from it. — wildplasser
– wildplasser, Commented Apr 6, 2014 at 17:38
Assuming you mean "a dump" when you say a "postgres file" ... what format is the dump? If it's an SQL format dump, you'd have to extract the part you want with a text editor. If it's a custom-format dump, you can use pg_restore with the -t flag. Use file the-dump-file to find out which it is if you do not know. — Craig Ringer
– Craig Ringer, Commented Apr 7, 2014 at 2:41

Craig Ringer · Accepted Answer · 2014-04-07 02:43:22Z

2

Assuming you mean "a dump" when you say a "postgres file":

If it's an SQL format dump, you'd have to extract the part you want with a text editor and run just that part. The dump is essentially an SQL "program" to re-create the database, so there's really no other way to selectively restore bits of it.

If it's a custom-format dump, you can use pg_restore with the -t flag.

Use file the-dump-file to find out which it is if you do not know. Or look at the file with a text editor - if the first five bytes are PGDMP it's a PostgreSQL custom format dump; otherwise it'll be an SQL format dump.

answered Apr 7, 2014 at 2:43

Craig Ringer

329k84 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to import data from a particular table from a large postgres file?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related