Psql
Appearance
Create database
tobiasco@main:/root$ psql CREATE DATABASE test2; psql: warning: extra command-line argument "test2" ignored psql: FATAL: Peer authentication failed for user "DATABASE"
Create table
tobiasco@main:/root$ psql test psql (9.3.1) Type "help" for help. test=> CREATE TABLE testtable test-> \dt test No matching relations found. test->
List roles
test-> \dg
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------+-----------
gis | | {}
postgres | Superuser, Create role, Create DB, Replication | {}
tobiasco | Create DB | {}
But http://www.postgresql.org/docs/9.3/static/sql-createdatabase.html says
"To create a database, you must be a superuser or have the special CREATEDB privilege."
Where to find "privilege"-listing?