From: | Michael Wood <esiotrot(at)gmail(dot)com> |
---|---|
To: | Marcin Krol <mrkafk(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Special table names |
Date: | 2010-02-26 13:18:21 |
Message-ID: | 5a8aa6681002260518q6be7a4a9k563bdfbeb88b82cc@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 26 February 2010 14:21, Marcin Krol <mrkafk(at)gmail(dot)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(at)gmail(dot)com>
From | Date | Subject | |
---|---|---|---|
Next Message | Marcin Krol | 2010-02-26 13:35:22 | Re: Special table names |
Previous Message | A. Kretschmer | 2010-02-26 12:31:05 | Re: Special table names |