From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | Demai Ni <nidmgg(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: foreign data wrapper option manipulation during Create foreign table time? |
Date: | 2014-10-28 22:00:14 |
Message-ID: | 545011EE.5040801@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Demai Ni | 2014-10-28 22:07:26 | Re: foreign data wrapper option manipulation during Create foreign table time? |
Previous Message | Merlin Moncure | 2014-10-28 21:35:52 | Re: lag_until_you_get_something() OVER () window function |