Request a Demo
Home   >   mailing lists

Re: TRUNCATE and CREATE TABLE LIKE for foreign tables - Mailing list pgsql-general

From Albe Laurenz
Subject Re: TRUNCATE and CREATE TABLE LIKE for foreign tables
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17DA7699@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to TRUNCATE and CREATE TABLE LIKE for foreign tables  (sri harsha <sriharsha9992@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: sri harsha
Date:
Subject: TRUNCATE and CREATE TABLE LIKE for foreign tables
Next
From: Joshua Boyd
Date:
Subject: Re: Postgres 9.2 PITR testing to before DROP DATABASE ends up removing file system files