Skip site navigation (1) Skip section navigation (2)

Re: Special table names

From: Michael Wood <esiotrot(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Marcin Krol <mrkafk(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Special table names
Date: 2010-02-26 14:54:48
Message-ID: 5a8aa6681002260654m71d41c5aqc9d426ffbca2f99a@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On 26 February 2010 16:51, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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.)

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

-- 
Michael Wood <esiotrot(at)gmail(dot)com>

In response to

pgsql-novice by date

Next:From: Michael WoodDate: 2010-02-26 14:59:22
Subject: Re: Special table names
Previous:From: Tom LaneDate: 2010-02-26 14:51:38
Subject: Re: Special table names

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group