Re: [HACKERS] foreign data wrapper option manipulation during Create foreign table time?

2014-10-30 Thread Ronan Dunklau
Le mercredi 29 octobre 2014 14:16:23 Demai Ni a écrit : > Robert and Ronan, > > many thanks for your response. > > I realized there is no clean way/api for it. maybe a hacking of ptree can > do the trick.. :-) > > I will also take a look at IMPORT FOREIGN SCHEMA. However, for this > requirement,

Re: [HACKERS] foreign data wrapper option manipulation during Create foreign table time?

2014-10-29 Thread Demai Ni
Robert and Ronan, many thanks for your response. I realized there is no clean way/api for it. maybe a hacking of ptree can do the trick.. :-) I will also take a look at IMPORT FOREIGN SCHEMA. However, for this requirement, I still need the user to input filename or filefolder, and I'd like to pr

Re: [HACKERS] foreign data wrapper option manipulation during Create foreign table time?

2014-10-29 Thread Ronan Dunklau
Le mercredi 29 octobre 2014 12:49:12 Robert Haas a écrit : > On Tue, Oct 28, 2014 at 5:26 PM, Demai Ni wrote: > > I am looking for a couple pointers here about fdw, and how to change the > > option values during CREATE table time. > > > > I am using postgres-xc-1.2.1 right now. For example, it co

Re: [HACKERS] foreign data wrapper option manipulation during Create foreign table time?

2014-10-29 Thread Robert Haas
On Tue, Oct 28, 2014 at 5:26 PM, Demai Ni wrote: > I am looking for a couple pointers here about fdw, and how to change the > option values during CREATE table time. > > I am using postgres-xc-1.2.1 right now. For example, it contains file_fdw, > whose create-table-stmt looks like: > CREATE FOREIG

Re: [HACKERS] foreign data wrapper option manipulation during Create foreign table time?

2014-10-28 Thread Demai Ni
hi, Andrew, thanks for the quick response. M understanding is that Alter Foreign Table can change the option values by user. What I need is to change the value programmatic inside foreign data wrapper code, and hope someone already done so I can learn from the existing design. I thought this ema

Re: [HACKERS] foreign data wrapper option manipulation during Create foreign table time?

2014-10-28 Thread Andrew Dunstan
On 10/28/2014 05:26 PM, Demai Ni wrote: hi, guys, I am looking for a couple pointers here about fdw, and how to change the option values during CREATE table time. I am using postgres-xc-1.2.1 right now. For example, it contains file_fdw, whose create-table-stmt looks like: CREATE FOREIGN T

[HACKERS] foreign data wrapper option manipulation during Create foreign table time?

2014-10-28 Thread Demai Ni
hi, guys, I am looking for a couple pointers here about fdw, and how to change the option values during CREATE table time. I am using postgres-xc-1.2.1 right now. For example, it contains file_fdw, whose create-table-stmt looks like: CREATE FOREIGN TABLE t1() SERVER file_server OPTIONS(format