Re: How do I get a list of DB's or Tables with a postgres SQL statement?

From: Alessio Bragadini <alessio(at)albourne(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: How do I get a list of DB's or Tables with a postgres SQL statement?
Date: 2001-10-18 10:10:03
Message-ID: 3BCEAA7B.63363315@albourne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Ron de Jong wrote:

> I know there is some funtions in psql:
>
> \l (show databases)
> \d (show tables)

If you start psql with the -E option, it will show you which queries it
makes to the internal tables to retrieve the backslash result. Then
copying and customizing your own query is very simple.

--
Alessio F. Bragadini alessio(at)albourne(dot)com
APL Financial Services http://village.albourne.com
Nicosia, Cyprus phone: +357-2-755750

"It is more complicated than you think"
-- The Eighth Networking Truth from RFC 1925

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Meskes 2001-10-18 10:54:41 Re: ecpg - GRANT bug
Previous Message Lee Kindness 2001-10-18 08:28:19 Re: compiling libpq++ on Solaris with Sun SPRO6U2 (fixed