Special table names

From: Marcin Krol <mrkafk(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Special table names
Date: 2010-02-26 12:21:36
Message-ID: 4B87BCD0.10403@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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?

Regards,
mk

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message A. Kretschmer 2010-02-26 12:31:05 Re: Special table names
Previous Message Thom Brown 2010-02-26 10:04:37 Re: Importing lines of variable length from ASCII