On Apr 4, 2005, at 5:11 AM, go wrote:
And pls one small question - what query will return me a list of tables in database ( \l - works only in psql)?
Startup of psql with the -E option (or use \set ECHO_HIDDEN 1). Then psql will show you the query it uses for \l or any other \ command.
John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend