Re: Special table names

Поиск
Список
Период
Сортировка
От Michael Wood
Тема Re: Special table names
Дата
Msg-id 5a8aa6681002260654m71d41c5aqc9d426ffbca2f99a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Special table names  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Special table names
Следующее
От: Michael Wood
Дата:
Сообщение: Re: Special table names