TRUNCATE and CREATE TABLE LIKE for foreign tables

Started by sri harshaover 11 years ago2 messagesgeneral
Jump to latest
#1sri harsha
sriharsha9992@gmail.com

Hi,

Is it possible to implement TRUNCATE and CREATE TABLE LIKE for a foreign
table. Is there anyway i can write a function to implement those queries in
my FDW ??

Thanks,
Harsha

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: sri harsha (#1)
Re: TRUNCATE and CREATE TABLE LIKE for foreign tables

sri harsha wrote:

Is it possible to implement TRUNCATE and CREATE TABLE LIKE for a foreign table. Is there anyway i
can write a function to implement those queries in my FDW ??

This is currently not possible, it would need an extension to the FDW API.

If you can come up with a good design, lobby for it in the hackers mailing list.

Yours,
Laurenz Albe

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general