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(at)postgreSQL(dot)org
> > [mailto:owner-pgsql-sql(at)postgreSQL(dot)org]On Behalf Of Marcio Macedo
> > Sent: Tuesday, December 07, 1999 2:42 AM
> > To: pgsql-sql(at)postgreSQL(dot)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."
>
>
>
> ************
>