Обсуждение: Read rows deleted

Поиск
Список
Период
Сортировка

Read rows deleted

От
Alejandro Carrillo
Дата:
Hi,

Anybody knows a JDBC or a multiplatform code that let read the delete rows of a table without writing of a table file?
Anybody knows how to create a table using a table file?

thanks

Re: Read rows deleted

От
Sergey Konoplev
Дата:
Hi,

On Wed, Dec 12, 2012 at 8:26 AM, Alejandro Carrillo <fasterzip@yahoo.es> wrote:
> Anybody knows a JDBC or a multiplatform code that let read the delete rows
> of a table without writing of a table file?
> Anybody knows how to create a table using a table file?

I am not sure what you mean but may be one of this links will help you:

- http://www.postgresql.org/docs/9.2/static/file-fdw.html
- http://pgxn.org/dist/odbc_fdw/.

>
> thanks



--
Sergey Konoplev
Database and Software Architect
http://www.linkedin.com/in/grayhemp

Phones:
USA +1 415 867 9984
Russia, Moscow +7 901 903 0499
Russia, Krasnodar +7 988 888 1979

Skype: gray-hemp
Jabber: gray.ru@gmail.com


Re: Read rows deleted

От
Alejandro Carrillo
Дата:
Hi,

Anybody knows how to create a table using a table file? It isn't a fdw, is a file that compose the table in postgresql and get with the pg_relation_filepath function. Ex:

select pg_relation_filepath('pg_proc');

Anybody knows a JDBC or a multiplatform code that let read the delete rows of a table without writing of a table file?

Thanks


De: Sergey Konoplev <gray.ru@gmail.com>
Para: Alejandro Carrillo <fasterzip@yahoo.es>
CC: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Enviado: Miércoles 12 de diciembre de 2012 15:13
Asunto: Re: [PERFORM] Read rows deleted

Hi,

On Wed, Dec 12, 2012 at 8:26 AM, Alejandro Carrillo <fasterzip@yahoo.es> wrote:
> Anybody knows a JDBC or a multiplatform code that let read the delete rows
> of a table without writing of a table file?
> Anybody knows how to create a table using a table file?

I am not sure what you mean but may be one of this links will help you:

- http://www.postgresql.org/docs/9.2/static/file-fdw.html
- http://pgxn.org/dist/odbc_fdw/.

>
> thanks



--
Sergey Konoplev
Database and Software Architect
http://www.linkedin.com/in/grayhemp

Phones:
USA +1 415 867 9984
Russia, Moscow +7 901 903 0499
Russia, Krasnodar +7 988 888 1979

Skype: gray-hemp
Jabber: gray.ru@gmail.com


Re: Read rows deleted

От
Andrew Dunstan
Дата:
On 12/12/2012 03:24 PM, Alejandro Carrillo wrote:
> Hi,
>
> Anybody knows how to create a table using a table file? It isn't a
> fdw, is a file that compose the table in postgresql and get with the
> pg_relation_filepath function. Ex:
>
> select pg_relation_filepath('pg_proc');
>
> Anybody knows a JDBC or a multiplatform code that let read the delete
> rows of a table without writing of a table file?
>
>


This isn't a performance related question. Please ask on the correct
list (probably pgsql-general).

cheers

andrew