Обсуждение: Read rows deleted
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
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
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
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