From: | Alejandro Carrillo <fasterzip(at)yahoo(dot)es> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Read recover rows |
Date: | 2012-12-13 23:30:13 |
Message-ID: | 1355441413.68454.YahooMailNeo@web172201.mail.ir2.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)gmail(dot)com>
>Para: Alejandro Carrillo <fasterzip(at)yahoo(dot)es>
>CC: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)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?
>
>
>-- Adrian Klaver
>adrian(dot)klaver(at)gmail(dot)com
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2012-12-13 23:39:53 | Re: Read recover rows |
Previous Message | Adrian Klaver | 2012-12-13 23:23:58 | Re: Read recover rows |