|Home | About | Partners | Contact Us|
# su - postgres bash-2.05$ createuser cermak Shall the new user be allowed to create databases? (y/n) y Shall the new user be allowed to create more new users? (y/n) n CREATE USERCreate a database (gcdb) in PostgreSQL from the newly created users account, using the 'createdb' command.
Installing the database:
After creating the user and the database, you can perform this little test on the command line:
[cermak]$ createdb gcdb CREATE DATABASE [cermak]$ psql gcdb Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit gcdb=> \q