I have a file CALLED 11649 in the path: %PG_DATA%\base\11912 This file is a table data in postgresql. Ex: pg_proc. Now I copied this file, renamed it and I want to connect this file to another new table with the same structure and data. How I can do this?
De: Adrian Klaver <adrian.klaver@gmail.com> Para: Alejandro Carrillo <fasterzip@yahoo.es> CC: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org> Enviado: Jueves 13 de diciembre de 2012 18:23 Asunto: Re: [GENERAL] Read recover rows
On 12/13/2012 03:14 PM, Alejandro Carrillo wrote: > Hi, > > 1) Isn't a script. The file is a table file get using the function > pg_relation_filepath: > select pg_relation_filepath('pg_proc');
The above does NOT return a file it just returns the file path name. Postgres stores it tables(relations) with numbers. This function just helps which number is associated with a table.
> 2) :( help!
Still not sure what you are trying to do:)
Wild guess, pg_proc was deleted and you want to recover it?
