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

Re: question on SELECT

From: Jie Liang <jliang(at)jliang(dot)ipinc(dot)com>
To: "Prasanth A(dot) Kumar" <kumar1(at)home(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: question on SELECT
Date: 2000-12-19 17:25:17
Message-ID: Pine.BSF.4.21.0012190924100.41305-100000@jliang.ipinc.com (view raw or flat)
Thread:
Lists: pgsql-sql
use:
\dt  -- all tables
\dv  -- all views
\df  -- all functions

...

Jie LIANG

Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang(at)ipinc(dot)com
www.ipinc.com

On 19 Dec 2000, Prasanth A. Kumar wrote:

> 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

pgsql-sql by date

Next:From: Jie LiangDate: 2000-12-19 17:35:42
Subject: Re: SQL query not working when GROUP BY / HAVING is used
Previous:From: Josh BerkusDate: 2000-12-19 16:43:41
Subject: Re: Tree structure table normalization problem (do I need a trigger?)

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