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: m38zpcde32.fsf@C654771-a.frmt1.sfba.home.com (view raw or flat)
Thread:
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
> CIM/MASTEC
> 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
kumar1(at)home(dot)com

In response to

Responses

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-2014 The PostgreSQL Global Development Group