RE: [SQL] getting table info

psql -E yourdbname


On Mon, 6 Dec 1999, Marcio Macedo wrote:

> 
> ok,
> but I need to do this in a query, so my PHP script can retrieve it to the
> client.
> 
> any ideas ?
> 
> On Tue, 7 Dec 1999, Sean Mullen wrote:
> 
> > 
> > \dt
> > 
> > -----Original Message-----
> > From: owner-pgsql-sql@postgreSQL.org
> > [mailto:owner-pgsql-sql@postgreSQL.org]On Behalf Of Marcio Macedo
> > Sent: Tuesday, December 07, 1999 2:42 AM
> > To: pgsql-sql@postgreSQL.org
> > Subject: [SQL] getting table info
> > 
> > 
> > 
> > is there a way to retrieve the information about the table names and 
> > columns in a database ?
> > 
> > something like select * from database or something...
> > 
> > thx
> > 
> > 
> > 
> 
> -- 
> --Marcio Macedo
>     Conectiva
> 
> "You're so boring boring boring
>  always tape machine recording
>  I've heard all this before
>  I've heard all this before
>  Your emotions make you a monster."
> 
> 
> 
> ************
>