Re: [ADMIN] Reg: sql commands

2005-09-22 Thread Stef
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

Re: [ADMIN] Reg: sql commands

2005-09-22 Thread sandhya
Thank you..Hannes - Original Message - From: "Hannes Dorbath" <[EMAIL PROTECTED]> To: Sent: Thursday, September 22, 2005 3:48 PM Subject: Re: [ADMIN] Reg: sql commands > Start psql with -E option to see the statements used internally. > > On 22.09.

Re: [ADMIN] Reg: sql commands

2005-09-22 Thread Hannes Dorbath
Start psql with -E option to see the statements used internally. On 22.09.2005 11:47, sandhya wrote: Is there any equivalent sql commands/queries for ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriat

Re: [ADMIN] Reg: sql commands

2005-09-22 Thread sandhya
MAIL PROTECTED]> Cc: "postgre" ; "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... > =>

Re: [ADMIN] Reg: sql commands

2005-09-22 Thread Stef
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

[ADMIN] Reg: sql commands

2005-09-22 Thread sandhya
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 ve