PostgreSQL psql. psql -h hostname dbname username :connect to a database as user \list or \l :list all databases \dt :list all tables in the current database drop table .