Skip site navigation (1) Skip section navigation (2)

Re: Reg: sql commands

From: Stef <svb(at)ucs(dot)co(dot)za>
To: "sandhya" <sandhyar(at)amiindia(dot)co(dot)in>
Cc: "postgre" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Reg: sql commands
Date: 2005-09-22 10:54:27
Message-ID: 20050922125427.1e60e1df@svb.ucs.co.za (view raw or flat)
Thread:
Lists: pgsql-admin
sandhya mentioned :
=> No...What i need is...
=> I want to know the equivalent sql queries for \l and \dt commands in order
=> to list the databases and tables.
=> I want to do it through programming

From the psql man-page :
-E

--echo-hidden
       Echoes the actual queries generated by \d  and  other  backslash
       commands.  You can use this if you wish to include similar func-
       tionality into your own programs. This is equivalent to  setting
       the variable ECHO_HIDDEN from within psql.

If this is not _exactly_ what you need, then you're not exactly 
explaining what you're trying to do :)

In response to

pgsql-admin by date

Next:From: Rajesh Kumar MallahDate: 2005-09-22 12:26:01
Subject: Is pgdump_all == pg_dumpall -g + pg_dump of individual databases ?
Previous:From: sandhyaDate: 2005-09-22 10:51:03
Subject: Re: Reg: sql commands

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group