Re: Special table names

On 26 February 2010 16:51, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Marcin Krol <mrkafk(at)gmail(dot)com> writes:
>> Michael Wood wrote:
>>> In addition to what Andreas said, try "\dS" (and "\?").
>
>> Thanks, that's useful -- but that still doesn't let me tell where 'user'
>> table (view? alias?) comes from.
>
> It isn't a table.  It's a function, equivalent to CURRENT_USER.
>
> (Both of those are mandated by the SQL spec; we'd certainly never have
> invented functions called without parentheses on our own desires.)

Ah. So that's where that confusion comes from.

--
Michael Wood <esiotrot(at)gmail(dot)com>