dbTalk Databases Forums  

List Data bases and users

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss List Data bases and users in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Manu M P
 
Posts: n/a

Default List Data bases and users - 12-11-2003 , 05:24 AM







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


Reply With Quote
  #2  
Old   
paul@entropia.co.uk
 
Posts: n/a

Default Re: List Data bases and users - 12-11-2003 , 05:33 AM






in psql

\l lists databases

\du lists users

hth
Paul Butler


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


Reply With Quote
  #3  
Old   
Aarni Ruuhimäki
 
Posts: n/a

Default Re: List Data bases and users - 12-11-2003 , 05:58 AM



Hi,

bash# psql -l

also lists databases.

BR,

Aarni

On Thursday 11 December 2003 13:24, you wrote:
Quote:
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 (AT) kymi (DOT) com | info (AT) kymi (DOT) 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.
-------------------------------------------------


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.