Thread: Howto list or display databases on a PostgreSQL PgSQL server
View Single Post

  #2 (permalink)  
Old 03-06-2007, 01:17 PM
nixcraft's Avatar
nixcraft nixcraft is offline
Never say die
User
  
Join Date: Jan 2005
Location: BIOS
My distro: Ubuntu
Posts: 1,061
Rep Power: 10
nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute
Default
Login to pgsql server using any one of the command:
Code:
su - postgres
psql template1
OR
Code:
su - postgres
psql -d template1 -U postgres
Type \l
Code:
 template1# \l
You can also use psql itself
Code:
su - postgres
psql -l
To get help type
Code:
\h
and
Code:
psql --help
__________________
Vivek | My personal blog
Linux Evangelist
Play hard stay cool
Reply With Quote