psql client for PostgreSQL

psql is a command line client for the PostgreSQL Database Engine. If you install postgreSQL on Debian psql is installed by default. After you switched to the postgteSQL user:

su postgres

you can access the client with this simpel command:

psql

and you can exit with this command:

\q

You can set a password with this command inside of the psql client:

ALTER ROLE postgres WITH ENCRYPTED PASSWORD 'postgres';

you can call the help with this command:

\?

It’s a mess! I think more “NOT SEXY” is not possible! MySQL is maybe not as good as PostgreSQL, but from the usability it is 10 times better. In MySQL the command for exit is “exit” not “\q” and for showing the databases the command is “show databases” and for showing tables “show tables”. Much more intuitive than PostgreSQL!