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 email list is for developer(ie, who change the code), and pgsql-general for users. Hence, send to here. If it is wrong place, I will switch the question over. Anyway, appreciate the response. And good point on Alter-foreign-table, probably some logic there I can copy over to create-table.... Demai On Tue, Oct 28, 2014 at 3:00 PM, Andrew Dunstan <and...@dunslane.net> wrote: > > 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 TABLE t1(....) >> SERVER file_server >> OPTIONS(format 'text',filename *'testing.txt'*); >> >> I would like to replace the 'testing.txt' with absolute path like >> '/user/testor1/testing.txt', and make sure the new value is saved in >> pg_foreign_table; the file_fdw_validator is used to validate the options, >> but is there a way to replace the optionValue here? And get the new value >> stored in pg_foreign_table? >> >> Thanks >> >> BTW, in my real use case, I am trying to interpret a hdfs file and would >> need to save some hostname/port information in the option value, which not >> necessary specified by user. >> >> > > This is the wrong list to ask this - it's a usage question that belongs on > pgsql-general > > See the documentation for ALTER FOREIGN TABLE. > > cheers > > andrew > >