Demo project

ssh root@*EIP*

wget https://sandbox-expriment-files.obs.cn-north-1.myhuaweicloud.com:443/20220525/GaussDB_opengauss_client_tools.zip

unzip GaussDB_opengauss_client_tools.zip

cd GaussDB_opengauss_client_tools/Euler2.8_arm_64/

tar -xvf GaussDB-Kernel-V500R001C20-EULER-64bit-gsql.tar.gz

source gsql_env.sh

gsql -h *Private IP address* -U root -d postgres -p 8000 -W yourpassword -r

\q

gsql --help

\copyright

\h

\help CREATE DATABASE

\?

gsql -h *Private IP address* -U root -d postgres -p 8000 -W yourpassword -l

gsql -V

gsql -h *Private IP address* -U root -d postgres -p 8000 -W yourpassword -q

create table t_test (firstcol int);

insert into t_test values(200);

select * from t_test;

\q

gsql -h *Private IP address* -U root -d postgres -p 8000 -W yourpassword -S

select * from t_test;

select * from t_test

\q

gsql -h *Private IP address* -U root -d postgres -p 8000 -W yourpassword -r

select * from t_test;

ssh username@ecs-ip-address

wget https://example.com/path/to/GaussDB_opengauss_client_tools.zip
unzip GaussDB_opengauss_client_tools.zip -d /path/to/destination

cd /path/to/destination/EulerOS_X86_64

cd /path/to/destination/EulerOS_X86_64
./gsql -d hccdp_db -h 192.168.0.183 -p 8000 -U hccdp

systemctl status gaussdb

systemctl start gaussdb

wget https://example.com/path/to/GaussDB_opengauss_client_tools.zip
unzip GaussDB_opengauss_client_tools.zip -d /path/to/destination
cd /path/to/destination/EulerOS_X86_64
./gsql -d hccdp_db -h 192.168.0.183 -p 8000 -U hccdp

cd /path/to/GaussDB_opengauss_client_tools/EulerOS_X86_64

./gsql -h 192.168.0.183 -U root -d postgres -p 8000 -W yourpassword -r

./gsql -d hccdp_db -h 192.168.0.183 -p 8000 -U hccdp

CREATE SCHEMA hccdp;
CREATE TABLE hccdp.nation (
  N_NATIONKEY INT PRIMARY KEY,
  N_NAME VARCHAR(25),
  N_REGIONKEY INT,
  N_COMMENT VARCHAR(152)
);

\copy hccdp.nation FROM '/path/to/nation.csv' WITH (FORMAT csv, HEADER true);
\copy hccdp.part FROM '/path/to/part.csv' WITH (FORMAT csv, HEADER true);
\copy hccdp.supplier FROM '/path/to/supplier.csv' WITH (FORMAT csv, HEADER true);
\copy hccdp.partsupp FROM '/path/to/partsupp.csv' WITH (FORMAT csv, HEADER true);
\copy hccdp.orders FROM '/path/to/orders.csv' WITH (FORMAT csv, HEADER true);
\copy hccdp.lineitem FROM '/path/to/lineitem.csv' WITH (FORMAT csv, HEADER true);

SELECT * FROM hccdp.nation;

CREATE OR REPLACE PROCEDURE proc_nation() AS $$
BEGIN
  -- Buraya prosedür içeriği gelecek
END;
$$ LANGUAGE plpgsql;