Once you have created a database, you can access it by:
- Running theÂ PostgreSQLÂ interactive terminal program, calledÂ psql, which allows you to interactively enter, edit, and executeÂ SQL commands.
- Using an existing graphical frontend tool likeÂ pgAdminÂ or an office suite withÂ ODBC orÂ JDBC support to create and manipulate a database. These possibilities are not covered in this tutorial.
- Writing a custom application, using one of the several available language bindings.
You probably want to start upÂ psql to try the examples in this tutorial. It can be activated for theÂ mydb database by typing the command:
$ psql mydb
If you do not supply the database name then it will default to your user account name. You already discovered this scheme in the previous section usingÂ createdb.
InÂ psql, you will be greeted with the following message:
psql (9.0.2) Type "help" for help. mydb=>