su - omm
gsql -r

gsql -d omm  -p 5432  -r

omm=#

select version();

version (openGauss 3.0.0 build 02c14696) compiled at 2022-04-01 18:12:00 commit 0 last mr on aarch64-unknown-linux-gnu, compiled by g++ (GCC) 7.3.0, 64-bit (1 row)

show server_version;

server_version
9.2.4
(1 row)

\copyright

GaussDB Kernel Database Management System
Copyright (c) Huawei Technologies Co., Ltd. 2018. All rights reserved.

CREATE TABLE customer_t
(  c_customer_sk             integer,   
 c_customer_id             char(5),    
 c_first_name              char(6),    
 c_last_name               char(8) 
) ;

INSERT INTO customer_t (c_customer_sk, c_customer_id, c_first_name,c_last_name) VALUES (3769, 5, 'Grace','White');

create index idx_customer_id on customer_t(c_customer_id);
\di

\pset border 2
SELECT * FROM customer_t;

gsql -d postgres  -p 5432  -r

\c postgres

Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "postgres" as user "omm".

show AUTOCOMMIT;

测试gsql中事务默认为自动提交功能
create table customer_new as select * from customer_t;

\q

\set AUTOCOMMIT off

INSERT INTO customer_t (c_customer_sk, c_customer_id, c_first_name,c_last_name) VALUES
(6885, 1, ‘Joes’, ‘Hunter’),
(4321, 2, ‘Lily’,‘Carter’),
(9527, 3, ‘James’, ‘Cook’),
(9500, 4, ‘Lucy’, ‘Bake’);

select * from customer_t;

gsql --help

gsql is the openGauss interactive terminal.
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=FILENAME execute commands from file, then exit
     -l, --list list available databases, then exit
     -v, --set=, --variable=NAME=VALUE
     set gsql variable NAME to VALUE
     -V, --version output version information, then exit
     -X, --no-gsqlrc do not read startup file (~/.gsqlrc)
     -1 ("one"), --single-transaction
     execute command file as a single transaction
     -?, --help show this help, then exit
    
Input and output options:
     -a, --echo-all echo all input from script
     -e, --echo-queries echo commands sent to server
     -E, --echo-hidden display queries that internal commands generate
     -k, --with-key=KEY the key for decrypting the encrypted file
     -L, --log-file=FILENAME send session log to file
     -m, --maintenance can connect to cluster during 2-pc transaction recovery
     -n, --no-libedit disable enhanced command line editing (libedit)
     -o, --output=FILENAME send query results to file (or |pipe)
     -q, --quiet run quietly (no messages, only query output)
     -C, --enable-client-encryption enable client encryption feature
     -s, --single-step single-step mode (confirm each query)
     -S, --single-line single-line mode (end of line terminates SQL command)
    
Output format options:
     if this parameter is set,use libedit
     -t, --tuples-only print rows only
     -T, --table-attr=TEXT set HTML table tag attributes (e.g., width, border)
     -x, --expanded turn on expanded table output
     -z, --field-separator-zero
     -A, --no-align unaligned table output mode
     -F, --field-separator=STRING
     set field separator (default: "|")
     -H, --html HTML table output mode
     -P, --pset=VAR[=ARG] set printing option VAR to ARG (see \pset command)
     -R, --record-separator=STRING
     set record separator (default: newline)
     -r set field separator to zero byte
     -0, --record-separator-zero
     set record separator to zero byte
     -2, --pipeline use pipeline to pass the password, forbidden to use in terminal
     must use with -c or -f
    
Connection options:
     -h, --host=HOSTNAME database server host or socket directory (default: "local socket")
     allow multi host IP address with comma separator in centralized cluster
     -p, --port=PORT database server port (default: "5432")
     -U, --username=USERNAME database user name (default: "omm")
     -W, --password=PASSWORD the password of specified database user
    
For more information, type "\?" (for internal commands) or "\help" (for SQL
    commands) from within gsql, or consult the gsql section in the openGauss documentation.

\?

General
     \copyright show openGauss 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
     \parallel [on [num]|off] toggle status of execute (currently off)
     \q quit gsql
    
    Query Buffer
     \e [FILE] [LINE] edit the query buffer (or file) with external editor
     \ef [FUNCNAME [LINE]] edit function definition with external editor
     \p show the contents of the query buffer
     \copy ... perform SQL COPY with data stream to the client host
     \echo [STRING] write string to standard output
     \i FILE execute commands from file
     \i+ FILE KEY execute commands from encrypted file
     \ir FILE as \i, but relative to location of current script
     \ir+ FILE KEY as \i+, but relative to location of current script
     \o [FILE] send all query results to file or |pipe
     \qecho [STRING] write string to query output stream (see \o)
     \r reset (clear) the query buffer
     \w FILE write query buffer to file

...

\h

Available help:
    ABORT CREATE DATA SOURCE DROP NODE GROUP
    ALTER APP WORKLOAD GROUP CREATE DATABASE DROP OPERATOR
    ALTER APP WORKLOAD GROUP MAPPING CREATE DIRECTORY DROP OWNED
    ALTER AUDIT POLICY CREATE EXTENSION DROP PACKAGE
    ALTER DATA SOURCE CREATE FOREIGN TABLE DROP PACKAGE BODY
    ALTER DIRECTORY CREATE INDEX DROP RESOURCE LABEL
    ALTER EXTENSION CREATE LANGUAGE DROP RESOURCE POOL
    ALTER DATABASE CREATE FUNCTION DROP PROCEDURE
    ALTER DEFAULT PRIVILEGES CREATE GROUP DROP PUBLICATION
    ALTER FOREIGN TABLE CREATE MASKING POLICY DROP ROLE
    ALTER FOREIGN TABLE FOR HDFS CREATE MATERIALIZED VIEW DROP ROW LEVEL SECURITY POLICY
    ALTER GROUP CREATE NODE GROUP DROP SERVER
...

评论