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
Thanks Sandhya ----- Original Message ----- From: "Stef" <[EMAIL PROTECTED]> To: "sandhya" <[EMAIL PROTECTED]> Cc: "postgre" <pgsql-admin@postgresql.org>; "sandhya" <[EMAIL PROTECTED]> Sent: Thursday, September 22, 2005 3:38 PM Subject: Re: [ADMIN] Reg: sql commands > psql -E > > To see what that does : > man psql > > sandhya mentioned : > => Hi... > => Is there any equivalent sql commands/queries for > => ' \l ' (which list out all the databases) and > => ' \dt ' ( Which lists all the Tables of the current database) > => If anybody knows Please tell me.Or If there is any way to get the info of databases and tables pls..Explain me > => This is very much required for me to proceed further.. > => > => Thank you very much....... > => > => -Sandhya > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
