View Single Post

   
  #2 (permalink)  
Old 04-24-2008, 06:17 PM
Alvaro Herrera
 
Posts: n/a
Default Re: Desc Commnad in pgsql?

TJ O'Donnell wrote:
> I like the table and other info from psql
> and find I sometimes need that info in my client programs.
> Are there any SQL/plpgsql functions that are analogous
> to the psql \dt, \ds, etc. commands?


If you start psql with the -E option it will show you the queries it
used to build the response tables.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply With Quote