6.4 Connecting to Advanced Server with psql

Table of Contents Previous Next


6 Configuring Advanced Server : 6.4 Connecting to Advanced Server with psql

psql is a command line client application that allows you to execute SQL commands and view the results. To open the edb-psql client, the client must be in your search path. The executable resides in the bin directory, under your Advanced Server installation.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\e90a6a42\Screen Shot 2017-09-13 at 10.28.19 AM.png
-d specifies the database to which psql will connect;
-U specifies the identity of the database user that will be used for the session.
If you have performed an installation with the interactive installer, you can access the psql client through the Applications or Start menu. Navigate through the EDB Postgres menu to the Advanced Server 10 menu; then, navigate through the Run SQL Command Line menu, selecting EDB-PSQL. When the Terminal window opens, provide connection information for your session.

6 Configuring Advanced Server : 6.4 Connecting to Advanced Server with psql

Table of Contents Previous Next