Обсуждение: [Feature Request] \dx show "options"
Hi guys, I was thinking that could be great to add a column in \dx showing the available options for each foreign data wrapper. Seems reasonable? -- -- Emanuel Calvo Helpame.com
2011/11/9 Emanuel Calvo <postgres.arg@gmail.com>: > Hi guys, > > I was thinking that could be great to add a column in \dx showing the available > options for each foreign data wrapper. > > Seems reasonable? > Sorry the spam guys, it necesary the sme for index collations. They appear in "\d+ table" but with "\di+" it doesn't describe or show the collation. Maybe a column or in the description field could be enough. -- -- Emanuel Calvo Helpame.com
On Wed, Nov 9, 2011 at 7:57 AM, Emanuel Calvo <postgres.arg@gmail.com> wrote: > I was thinking that could be great to add a column in \dx showing the available > options for each foreign data wrapper. > > Seems reasonable? \dx doesn't list foreign data wrappers. \dew+ lists the actual options supplied to a foreign data wrapper already. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
2011/11/9 Robert Haas <robertmhaas@gmail.com>:
> On Wed, Nov 9, 2011 at 7:57 AM, Emanuel Calvo <postgres.arg@gmail.com> wrote:
>> I was thinking that could be great to add a column in \dx showing the available
>> options for each foreign data wrapper.
>>
>> Seems reasonable?
>
> \dx doesn't list foreign data wrappers.
>
I was confused, forget it.
> \dew+ lists the actual options supplied to a foreign data wrapper already.
>
Checked, but the options doesn't appear (the column exists, but is empty).
postgres=# \dew+ List of foreign-data wrappers Name | Owner | Handler |
Validator |
Access privileges | Options
-----------+----------+-------------------+---------------------+-------------------+---------file_fdw | postgres |
file_fdw_handler | file_fdw_validator | |mysql_fdw | postgres | mysql_fdw_handler | mysql_fdw_validator |
|
(2 rows)
--
--
Emanuel Calvo
Helpame.com
On Wed, Nov 9, 2011 at 12:31 PM, Emanuel Calvo <postgres.arg@gmail.com> wrote: >> \dew+ lists the actual options supplied to a foreign data wrapper already. > > Checked, but the options doesn't appear (the column exists, but is empty). Well, that just means that you didn't specify any options when you ran CREATE FOREIGN DATA WRAPPER. rhaas=# create foreign data wrapper dummy options (foo 'bar'); CREATE FOREIGN DATA WRAPPER rhaas=# \dew+ List of foreign-data wrappersName | Owner | Handler | Validator | Access privileges| FDW Options | Description -------+-------+---------+-----------+-------------------+-------------+-------------dummy | rhaas | - | - | | (foo 'bar') | (1 row) I'm not sure we're talking about the same thing, though. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
2011/11/10 Robert Haas <robertmhaas@gmail.com>: > On Wed, Nov 9, 2011 at 12:31 PM, Emanuel Calvo <postgres.arg@gmail.com> wrote: >>> \dew+ lists the actual options supplied to a foreign data wrapper already. >> >> Checked, but the options doesn't appear (the column exists, but is empty). > > Well, that just means that you didn't specify any options when you ran > CREATE FOREIGN DATA WRAPPER. > > rhaas=# create foreign data wrapper dummy options (foo 'bar'); > CREATE FOREIGN DATA WRAPPER > rhaas=# \dew+ > List of foreign-data wrappers > Name | Owner | Handler | Validator | Access privileges | FDW Options > | Description > -------+-------+---------+-----------+-------------------+-------------+------------- > dummy | rhaas | - | - | | (foo 'bar') | > (1 row) > > I'm not sure we're talking about the same thing, though. > No. I thought 'options' were the parameters when you create a fdw (example: host, port, file, etc). -- -- Emanuel Calvo Helpame.com
On Mon, Nov 14, 2011 at 10:45 AM, Emanuel Calvo <postgres.arg@gmail.com> wrote: > 2011/11/10 Robert Haas <robertmhaas@gmail.com>: >> On Wed, Nov 9, 2011 at 12:31 PM, Emanuel Calvo <postgres.arg@gmail.com> wrote: >>>> \dew+ lists the actual options supplied to a foreign data wrapper already. >>> >>> Checked, but the options doesn't appear (the column exists, but is empty). >> >> Well, that just means that you didn't specify any options when you ran >> CREATE FOREIGN DATA WRAPPER. >> >> rhaas=# create foreign data wrapper dummy options (foo 'bar'); >> CREATE FOREIGN DATA WRAPPER >> rhaas=# \dew+ >> List of foreign-data wrappers >> Name | Owner | Handler | Validator | Access privileges | FDW Options >> | Description >> -------+-------+---------+-----------+-------------------+-------------+------------- >> dummy | rhaas | - | - | | (foo 'bar') | >> (1 row) >> >> I'm not sure we're talking about the same thing, though. >> > > No. I thought 'options' were the parameters when you create a fdw (example: > host, port, file, etc). Each FDW can make its own decisions about which options it wants to support - the core server support doesn't know anything about how the data will be used. You can set options on the FDW level, the server level, the foreign table level, and maybe a few other places. Normally I would expect things like host and port to be set on the server level, rather than the foreign data wrapper level. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
2011/11/14 Robert Haas <robertmhaas@gmail.com>: > On Mon, Nov 14, 2011 at 10:45 AM, Emanuel Calvo <postgres.arg@gmail.com> wrote: >> 2011/11/10 Robert Haas <robertmhaas@gmail.com>: >>> On Wed, Nov 9, 2011 at 12:31 PM, Emanuel Calvo <postgres.arg@gmail.com> wrote: >>>>> \dew+ lists the actual options supplied to a foreign data wrapper already. >>>> >>>> Checked, but the options doesn't appear (the column exists, but is empty). >>> >>> Well, that just means that you didn't specify any options when you ran >>> CREATE FOREIGN DATA WRAPPER. >>> >>> rhaas=# create foreign data wrapper dummy options (foo 'bar'); >>> CREATE FOREIGN DATA WRAPPER >>> rhaas=# \dew+ >>> List of foreign-data wrappers >>> Name | Owner | Handler | Validator | Access privileges | FDW Options >>> | Description >>> -------+-------+---------+-----------+-------------------+-------------+------------- >>> dummy | rhaas | - | - | | (foo 'bar') | >>> (1 row) >>> >>> I'm not sure we're talking about the same thing, though. >>> >> >> No. I thought 'options' were the parameters when you create a fdw (example: >> host, port, file, etc). > > Each FDW can make its own decisions about which options it wants to > support - the core server support doesn't know anything about how the > data will be used. You can set options on the FDW level, the server > level, the foreign table level, and maybe a few other places. > Normally I would expect things like host and port to be set on the > server level, rather than the foreign data wrapper level. > Gotcha. Thanks Robert! I must report to the fdw creator. -- -- Emanuel Calvo Helpame.com