Re: SHOW

> > > What is the equivalent to the mysql's:
> > > SHOW COLUMNS FROM [TABLENAME];
> >
> > in psql,  \d will show you all tables and \d TABLE will show you the
> > columns in the table.  If you need it as a sql command,  you can check
the
> > system tables.
>
> OK. That works for ./bin/psql, but NOT on the libpq's PQexec.
> What do I have to type here?
>
> Thanx again and lots of greetings from cool Spain
> Steve

Start up psql with the -E on the command line. Then do \d TABLE. This will
show you the actual SQL commands used by psql.

See the psql man page for more details.

HTH,

-- Joe