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.)
regards, tom lane