Re: [Feature Request] \dx show "options"

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