how to "pg_dump", based in select command - Mailing list pgsql-hackers

Hello folks.

I want to know how to dump some parts of a database?

I need to extract the records in a "select * from table" and the pg_dump or other tool will create a file with the records found in this "select command", and after this, i will restore this file in another database with the same structure.

Any idea?

Thanks people.

 

Jeferson Kasper