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

Re: question on SELECT

From: kumar1(at)home(dot)com (Prasanth A(dot) Kumar)
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: question on SELECT
Date: 2000-12-19 08:12:33
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
Howard Hiew <howard(at)cim(dot)mastec(dot)com(dot)sg> writes:

> Hi,
> I would like to know what is the sql statement that list all the tables
> name.
> For example in Oracle,
> 'SELECT TABLE_NAME from ALL_TABLES where owner="Oracle" ';
> What is the statement for Postgres?
> Thank you
> Best Regards,
> Howard
> Tel:(65)8605283

You can do '\dt' to list all tables. There is also a system table
'pg_tables' which you can use if you like to do a select instead. Do
 SELECT tablename FROM pg_tables where tableowner='postgres';

Prasanth Kumar

In response to


pgsql-sql by date

Next:From: Tulassay ZsoltDate: 2000-12-19 09:21:18
Subject: Re: Tree structure table normalization problem (do I need a trigger?)
Previous:From: Howard HiewDate: 2000-12-19 06:17:14
Subject: RE: question on SELECT

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