Re: SHOW

From: Stephan Bergmann <sb(at)ows(dot)es>
To: bpalmer <bpalmer(at)crimelabs(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SHOW
Date: 2001-09-04 06:32:34
Message-ID: 3B947582.5D3754B8@ows.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!
>
> > 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

In response to

  • Re: SHOW at 2001-09-03 19:13:25 from bpalmer

Responses

  • Re: SHOW at 2001-09-04 06:50:35 from Joe Conway

Browse pgsql-general by date

  From Date Subject
Next Message John Clark Naldoza y Lopez 2001-09-04 06:47:24 Re: how do functional indices work?
Previous Message hubert depesz lubaczewski 2001-09-04 05:59:59 how do functional indices work?