On 3/20/2014 4:45 PM, Raymond O'Donnell wrote:
On 20/03/2014 07:48, Bhim Kumar wrote:
Hi sir
Currently I am using following query on mysql :
* SHOW TABLES; ---> To get list of table in a particular db.
Assuming you're using psql, did you take the advice you're given on
connection and type "help"?
Anyway, to see a list of tables just enter:
\d
Lots of handy backslash commands are available - \? will tell you more,
as will the fine manual:
http://www.postgresql.org/docs/9.3/static/app-psql.html
Ray.
Yep, and if you are writing code, then all that info is in the
information_schema.
try:
select * from information_schema.tables
and
select * from information_schema.columns
etc.
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
