nixCraft
Howto list or display databases on a PostgreSQL PgSQL server
This is a discussion on Howto list or display databases on a PostgreSQL PgSQL server within the Databases servers forums, part of the Mastering Servers category; Hai all, How do I list database names on a PostgreSQL database server? TIA...
|
|||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
03-06-2007, 12:13 PM
|
||||
|
||||
Howto list or display databases on a PostgreSQL PgSQL server
Hai all,
How do I list database names on a PostgreSQL database server? TIA 
|
| Sponsored Links | ||
|
|
|
03-06-2007, 12:17 PM
|
||||
|
||||
|
Login to pgsql server using any one of the command:
Code:
su - postgres psql template1 Code:
su - postgres psql -d template1 -U postgres Code:
template1# \l Code:
su - postgres psql -l Code:
\h Code:
psql --help
|
 |
| Bookmarks |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| UNIX Display or list number of files in a current directory | raj | Getting started tutorials | 1 | 12-07-2007 10:55 AM |
| MySQL remote server access howto | raj | Databases servers | 0 | 07-29-2007 05:32 AM |
| Oracle "show databases" list | raj | Databases servers | 1 | 05-18-2007 01:21 AM |
| How do I backup MySQL Databases? | chiku | All about FreeBSD/OpenBSD/NetBSD | 2 | 08-19-2006 07:15 PM |
| ReCompiling PHP with Pgsql | sonaikar | Linux software | 1 | 02-23-2006 04:42 PM |
All times are GMT +5.5. The time now is 12:16 AM.
