Re: all tables in a DB\? - Mailing list pgsql-sql

From Christopher Kings-Lynne
Subject Re: all tables in a DB\?
Date
Msg-id GNELIHDDFBOCMGBFGEFOOEIECBAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to all tables in a DB\?  ("D'laila Pereira" <dlailap@home.com>)
List pgsql-sql
select * from pg_table;

Chris

> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of D'laila Pereira
> Sent: Monday, 18 February 2002 3:52 PM
> To: pgsql-sql@postgresql.org
> Subject: [SQL] all tables in a DB\?
> 
> 
> What SQL command can I issue in Postgresql to list all the tables in a
> database?
> 
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Trying to convert a TIMESTAMP return value to TIME
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: create index on function - why?