| \l (lowercase L) | list all databases |
| \c | use database |
| \dt | show tables |
| \dT | list datatypes |
| \df | list functions |
| \di | list indexes |
| \dv | list views |
| \du | list users |
| \d+ | show all tables with descriptions |
| \d+ table | show table definition or view definition with column descriptions |
Renaming a table
PostgreSQL also called Postgres is an object-relational database management system that focuses on extensibility and standards-compliance.
This quick walk-through are my notes for installing the PostgreSQL database server and the PgAdmin administration application on Ubuntu Linux, and also set up the server so it allows access to other PC's on your network.
Right for the basic installation, at the command-line, enter the following commands (or search for the listed packages in synaptic if you prefer that way of working):
phpPgAdmin is a web-based administration tool for PostgreSQL written in PHP. It is a very nifty tool with a very convenient GUI interface. If you have used phpMyAdmin for MySQL, this phpMyAdmin for PostgreSQL.
To install phpPgAdmin on Ubuntu, to the following: