Re: SQL/MED - file_fdw

Thom Brown <thom@linux.com> writes:
> Is this right?
> postgres=# \d+ agg_text
>             Foreign table "public.agg_text"
>  Column |   Type   | Modifiers | Storage  | Description
> --------+----------+-----------+----------+-------------
>  a      | smallint |           | plain    |
>  b      | text     |           | extended |
> Server: file_server
> Has OIDs: no


> It says the agg_text foreign table is using extended storage for the
> text field.  If it's in-file, how can it be classified as potentially
> TOASTed?

It's meaningless, but I don't think it's worth trying to suppress the
meaningless column(s) ...

			regards, tom lane