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

Re: Special table names

From: Marcin Krol <mrkafk(at)gmail(dot)com>
To:
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Special table names
Date: 2010-02-26 13:35:22
Message-ID: 4B87CE1A.9000205@gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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.

> You should probably use "CREATE ROLE", "ALTER ROLE", "DROP ROLE" etc.
> instead of manipulating pg_user directly.

I have no intention to do that; I just created test db via ORM called 
SQLAlchemy, with table named 'user'.

Then I drop into psql, do 'select * from user' to see what's in there 
and I don't see what I expected to see:

ts=# \c ts;

ts=# select * from user;
  current_user
--------------
  postgres
(1 row)


So I'm wondering if there are other special table names I should avoid.

Regards,
mk


In response to

Responses

pgsql-novice by date

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

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