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>