Postgres list databases
Home
Articles
Java
Speaking
Raspberry Pi
Calculators
FIX Protocol
Published May 25th, 2011
Here is how to list your databases in postgres from the command line (using psql) and from within psql.
From the command line
psql -l
From within psql
\l
Leave comments, ask questions, or suggest improvements
Feel free to leave comments or suggest improvements. Comments will be moderated / approved to preserve the signal-to-noise ratio.
Name
Comment
Similar Articles
PostgreSQL 9 pgcrypto Debian
Postgresql increase SHMMAX with sysctl
Postgresql add cascade to existing foreign key constraint
PostgreSQL output query result to file
PostgreSQL /var/lib/postgresql/8.4/main/pg_xlog filling up with WAL files
PostgreSQL drop unique constraint
PostgreSQL DROP NULL constraint on COLUMN
SQL get MAX value or NULL (LEFT JOIN example)
Ubuntu sudo postgres createdb
Select unique values in postgres
Load specific columns from CSV file into PostgreSQL
Postgres copy table structure inside database without data
PostgreSQL Debian make a baseline backup for PITR
PostgreSQL config, data, log files on Debian
FATAL: sorry, too many clients already (PostgreSQL)
Run PostgreSQL queries from the command line and export data
Get SEDOL from ISIN using SQL (Postgres)
PostgreSQL convert BIGINT to date
Find biggest tables in postgres
Install pgcrypto for Postgres encryption in Debian Lenny
Create and export PGP keys for Postgresql
Postgres invalid byte sequence for encoding UTF8
Postgres list user-defined stored procedures
Postgres dump database schema with or without data
Postgres server to server database copy performance boost
All content on this website is Copyright 2003 - 2018 Chris Newland
Privacy Policy
Leave comments, ask questions, or suggest improvements