From: | Demai Ni <nidmgg(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | foreign data wrapper option manipulation during Create foreign table time? |
Date: | 2014-10-28 21:26:22 |
Message-ID: | CAOEq2C434D1and0DQOt7qbF5NB1nQnno6B+RUiJGMyMvSJntMw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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.
Demai
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2014-10-28 21:35:52 | Re: lag_until_you_get_something() OVER () window function |
Previous Message | David E. Wheeler | 2014-10-28 21:25:02 | Re: Trailing comma support in SELECT statements |