Re: Special table names

On 26 February 2010 14:21, Marcin Krol <mrkafk@gmail.com> wrote:
> Hello everyone,
>
> I googled I swear. And yet:
>
>
> postgres=# select * from user;
>  current_user
> --------------
>  postgres
> (1 row)
>
>
> postgres=# \c postgres
> psql (8.4.2)
> WARNING: Console code page (852) differs from Windows code page (1250)
>         8-bit characters might not work correctly. See psql reference
>         page "Notes for Windows users" for details.
> You are now connected to database "postgres".
>
> postgres=# select * from user;
>  current_user
> --------------
>  postgres
> (1 row)
>
>
> postgres=# \dt
> No relations found.
>
> OK so there's a table 'user' which is not located in 'postgres' db, so where
> is it?
>
> Other special tables?

In addition to what Andreas said, try "\dS" (and "\?").

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

--
Michael Wood <esiotrot@gmail.com>