Running the Greenplum Client Tools

Parent topic: Greenplum Database Client Tools for Windows

Users and administrators always connect to Greenplum Database through the master host. In order to establish a connection to the Greenplum Database master, you will need to know the following connection information and configure your client program accordingly. See Configuring the Client Tools for more information.

Running psql.exe

Depending on the default values used or the environment variables you have set, the following examples show how to access a database in Greenplum Database via psql:

If a user-defined database has not yet been created, you can access the system by connecting to the database. For example:

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 executed. For example:

For more information on using the psql.exe client application, see psql.exe. For more information on SQL commands and syntax, see .