find table name

From: Ashok Chauhan <ashok(at)kalculate(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: find table name
Date: 2003-12-06 11:34:10
Message-ID: 1070710450.1265.7.camel@chi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


hi
In postgresql all databases are stored in /data/base directory in
numbers form and all the related tables with that database are stored in
that directory again in numbers form.
so there is any command or query to see the original table names.
just like:- select * from pg_stat_database; for databases.

thank you
have a nice day.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ashok Chauhan 2003-12-06 11:41:36 insert & update query
Previous Message Bruce Momjian 2003-12-06 10:28:51 Re: Misplaced modifier in Postgresql license