Обсуждение: List Data bases and users

Friends

 Is there any way to list all the data bases available in a host?
 Also is there any way to list the users in the system?

thanks

in psql

\l lists databases

\du lists users

hth
Paul Butler

Hi,

bash# psql -l

also lists databases.

BR,

Aarni

On Thursday 11 December 2003 13:24, you wrote:
> Friends
>
>  Is there any way to list all the data bases available in a host?
>  Also is there any way to list the users in the system?
>
> thanks
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html

--
-------------------------------------------------
Aarni Ruuhimäki | Megative Tmi | KYMI.com
Pääsintie 26 | 45100 Kouvola | FINLAND
www.kymi.com | cfm.kymi.com
aarni.ruuhimaki@kymi.com | info@kymi.com
+358-5-3755 035 | +358-50-4910 037
-------------------------------------------------
Microsoft should change into vacuum cleaner
business where people actually want products
that suck.
-------------------------------------------------
This is a bugfree broadcast to you from a linux system.
-------------------------------------------------