Updated on 2022-12-16 GMT+08:00

gsql

Background

gsql is a database connection tool provided by GaussDB(DWS) and used by executing commands. You can use gsql to connect to a server and perform O&M on the server. In addition to the basic functions of operating on a database, gsql provides advanced features.

Function Description

  • Connecting to the database: By default, you can connect to only the local server. To connect to a remote database, configure the server first.
  • Running SQL commands: You can enter and run SQL commands interactively or run the SQL commands specified in a file.
  • Running meta-commands: Meta-commands help administrators view database object information, query cache information, format SQL output, and connect to a new database.