Special table names - Mailing list pgsql-novice

From Marcin Krol
Subject Special table names
Date
Msg-id 4B87BCD0.10403@gmail.com
Whole thread Raw
Responses Re: Special table names  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: Special table names  (Michael Wood <esiotrot@gmail.com>)
List 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

pgsql-novice by date:

Previous
From: Thom Brown
Date:
Subject: Re: Importing lines of variable length from ASCII
Next
From: "A. Kretschmer"
Date:
Subject: Re: Special table names