Re: Special table names

Marcin Krol <mrkafk@gmail.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.)

            regards, tom lane