Re: Special table names - Mailing list pgsql-novice

From Michael Wood
Subject Re: Special table names
Date
Msg-id 5a8aa6681002260654m71d41c5aqc9d426ffbca2f99a@mail.gmail.com
Whole thread Raw
In response to Re: Special table names  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
On 26 February 2010 16:51, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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.)

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

--
Michael Wood <esiotrot@gmail.com>

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Special table names
Next
From: Michael Wood
Date:
Subject: Re: Special table names