Depending on the default values used or the environment variables you have set, the following examples show how to access a database via psql
:
$ psql -d gpdatabase -h master_host -p 5432 -U `gpadmin`
$ psql gpdatabase
$ psql
If a user-defined database has not yet been created, you can access the system by connecting to the postgres
database. For example:
$ psql postgres
After connecting to a database, psql
provides a prompt with the name of the database to which psql
is currently connected, followed by the string =>
(or =#
if you are the database superuser). For example:
gpdatabase=>
At the prompt, you may type in SQL commands. A SQL command must end with a ;
(semicolon) in order to be sent to the server and run. For example:
=> SELECT * FROM mytable;
See the Greenplum Reference Guide for information about using the psql
client application and SQL commands and syntax.
Parent topic: Accessing the Database