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;
So I'm wondering if there are other special table names I should avoid.
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2010-02-26 14:51:38|
|Subject: Re: Special table names |
|Previous:||From: Michael Wood||Date: 2010-02-26 13:18:21|
|Subject: Re: Special table names|