Obtaining Help Information
Procedure
- When connecting to the database, run the following command to obtain the help information:
gsql --help
The following help information is displayed:
...... Usage: gsql [OPTION]... [DBNAME [USERNAME]] General options: -c, --command=COMMAND run only single command (SQL or internal) and exit -d, --dbname=DBNAME database name to connect to (default: "omm") -f, --file=<FILE_NAME> execute commands from file, then exit ......
- When connecting to the database, run the following command to obtain the help information:
help
The following help information is displayed:
You are using gsql, the command-line interface to gaussdb. Type: \copyright for distribution terms \h for help with SQL commands \? for help with gsql commands \g or terminate with semicolon to execute query \q to quit
Examples
- Connect to the database.
gsql -d gaussdb -p 8000
gaussdb is the name of the database, and 8000 is the port number of the CN.
If information similar to the following is displayed, the connection succeeds:
gsql ((GaussDB Kernel 503.1.XXX build f521c606) compiled at 2021-09-16 14:55:22 commit 2935 last mr 6385 release) Non-SSL connection (SSL connection is recommended when requiring high-security) Type "help" for help.
- View the gsql help information. For details, see Table 1.
Table 1 gsql online help Description
Example
Query the copyright.
\copyright
View help information about SQL statements supported by GaussDB.
View help information about SQL statements supported by GaussDB.
For example, view all SQL statements supported by GaussDB.
1 2 3 4 5 6
gaussdb=# \h Available help: ABORT ALTER AGGREGATE ... ...
For example, view parameters of the CREATE DATABASE command:
1 2 3 4 5 6 7 8 9 10 11 12 13
gaussdb=# \help CREATE DATABASE Command: CREATE DATABASE Description: create a new database Syntax: CREATE DATABASE database_name [ [ WITH ] {[ OWNER [=] user_name ]| [ TEMPLATE [=] template ]| [ ENCODING [=] encoding ]| [ LC_COLLATE [=] lc_collate ]| [ LC_CTYPE [=] lc_ctype ]| [ DBCOMPATIBILITY [=] compatibility_type ]| [ TABLESPACE [=] tablespace_name ]| [ CONNECTION LIMIT [=] connlimit ]}[...] ];
View the help information about gsql commands.
For example, view commands supported by gsql.
1 2 3 4 5 6 7
gaussdb=# \? General \copyright show GaussDB Kernel usage and distribution terms \g [FILE] or ; execute query (and send results to file or |pipe) \h(\help) [NAME] help on syntax of SQL commands, * for all commands \q quit gsql ... ...
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot