Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group