Thread: RE: [SQL] getting table info

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 MacedoConectiva

"You're so boring boring boringalways tape machine recordingI've heard all this beforeI've heard all this beforeYour
emotionsmake you a monster."
 

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."
> 
> 
> 
> ************
>