Re: Special table names - Mailing list pgsql-novice

From Tom Lane
Subject Re: Special table names
Date
Msg-id 26736.1267195898@sss.pgh.pa.us
Whole thread Raw
In response to Re: Special table names  (Marcin Krol <mrkafk@gmail.com>)
Responses Re: Special table names  (Michael Wood <esiotrot@gmail.com>)
Re: Special table names  (Marcin Krol <mrkafk@gmail.com>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Marcin Krol
Date:
Subject: Re: Special table names
Next
From: Michael Wood
Date:
Subject: Re: Special table names