PostgreSQL

This section is all about PostgreSQL: The world's most advanced open source database.

The "standard" client or admin utility is pgAdmin - PostgreSQL Tools which actually runs in a browser and is written in Python. It also includes the psql command line utility.

Command Line

There is a PostgreSQL command line utility called psql, this is documented at PostgreSQL: Documentation: psql.

Setting up Command Line

One very useful thing is setting up a password file, see PostgreSQL: Documentation: 12: 33.15. The Password File for details on this, which does work rather nicely.