Re: Read recover rows - Mailing list pgsql-general

From Alejandro Carrillo
Subject Re: Read recover rows
Date
Msg-id 1355442096.85219.YahooMailNeo@web172202.mail.ir2.yahoo.com
Whole thread Raw
In response to Re: Read recover rows  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: Read recover rows
List pgsql-general
Are you trying to recover a table by copying in a table from somewhere else? Yes because I can't modify the original file

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:39
Asunto: Re: [GENERAL] Read recover rows

On 12/13/2012 03:30 PM, Alejandro Carrillo wrote:
> 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?

As far as I know you cannot. If you want to create a new table from an existing table you will need to use the SQL commands I mentioned previously. This assumes the original table exists. Are you trying to recover a table by copying in a table from somewhere else?

>
>


-- Adrian Klaver
adrian.klaver@gmail.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Read recover rows
Next
From: Edson Richter
Date:
Subject: Re: XML Schema for PostgreSQL database