Re: Read recover rows

On 12/13/2012 03:41 PM, Alejandro Carrillo wrote:
> Are you trying to recover a table by copying in a table from somewhere
> else? Yes because I can't modify the original file

You will not be able to work with the disk file directly, you will need
to go through the database.

Have you tried pg_dump:

http://www.postgresql.org/docs/9.2/interactive/app-pgdump.html

Something like:

pg_dump -t some_table -f some_table.sql -U some_user database_name

Where the dummy names are replaced with the table/database you want.

This will create a plain text file. If you need to change the name you
could do find and replace on the table name.

This assumes you are trying to move a user created table not a system
table.
Is that the case?

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com