EDB*Plus User’s Guide

This guide describes how to connect to an Advanced Server database using EDB*Plus. EDB*Plus provides a command line user interface to EDB Postgres Advanced Server that accepts SQL commands that allow you to:

• Query certain database objects

• Execute stored procedures

• Format output from SQL commands

• Execute batch scripts

• Execute OS commands

• Record output

For detailed information about the features supported by Advanced Server, please consult the complete library of Advanced Server guides available at:

https://www.enterprisedb.com/edb-docs

• EDB*Plus
• Installing EDB*Plus
  • Installation Pre-Requisites
  • Performing an RPM Installation
    • Configuring an RPM Installation
  • Using the Graphical Installer
• Using EDB*Plus
• Using a Secure Sockets Layer (SSL) Connection
  • Configuring SSL on Advanced Server
    • Configuring SSL for the EDB*Plus Client
    • Requesting an SSL Connection between EDB*Plus and the Advanced Server Database
• Command Summary
  • ACCEPT
  • APPEND
  • CHANGE
  • CLEAR
  • COLUMN
  • CONNECT
  • DEFINE
  • DEL
  • DESCRIBE
  • DISCONNECT
  • EDIT
  • EXECUTE
  • EXIT
  • GET
  • HELP
  • HOST
  • INPUT
  • LIST
  • PASSWORD
  • PAUSE
  • PROMPT
  • QUIT
  • REMARK
  • SAVE
  • SET
  • SHOW
  • SPOOL
  • START
  • UNDEFINE
  • WHENEVER SQLERROR
• Conclusion