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: (view raw or whole 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-2015 The PostgreSQL Global Development Group