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 majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly