nixCraft
Linux / UNIX Tech Support Forum
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 free or login to your existing account and remove all advertisements. |
|
|||||||
| Databases servers Discussions of databases of all types - especially MySQL. |
 |
|
|
LinkBack | Thread Tools | Display Modes |
03-06-2007, 01: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, 01: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
__________________
Vivek Gite Linux Evangelist  Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group. Always use CODE tags for posting system output and commands! Do you run a Linux? Let's face it, you need help
|
|
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 11:55 AM |
| MySQL remote server access howto | raj | Databases servers | 0 | 07-29-2007 06:32 AM |
| Oracle "show databases" list | raj | Databases servers | 1 | 05-18-2007 02:21 AM |
| How do I backup MySQL Databases? | chiku | All about FreeBSD/OpenBSD/NetBSD | 2 | 08-19-2006 08:15 PM |
| ReCompiling PHP with Pgsql | sonaikar | Linux software | 1 | 02-23-2006 05:42 PM |
All times are GMT +5.5. The time now is 04:40 PM.
