abcd

CREATE USER hccdp WITH SYSADMIN PASSWORD 'sadece1234';

CREATE DATABASE hccdp_db OWNER hccdp TEMPLATE template0 ENCODING 'UTF8';

gsql -d hccdp_db -U hccdp -p 5432

CREATE SCHEMA hccdp;
\i /root/create_table.sql

SELECT u.usename, n.nspname, d.datname, t.tablename 
FROM pg_user u, pg_namespace n, pg_database d, pg_tables t 
WHERE u.usename='hccdp' AND n.nspname='hccdp' AND d.datname='hccdp_db' AND t.schemaname='hccdp';

wget https://labfiles-singapore.obs.ap-southeast-3.myhuaweicloud.com/data.zip
unzip lab_data.zip

\copy nation FROM 'nation.csv' DELIMITER ',' CSV;
\copy part FROM 'part.csv' DELIMITER ',' CSV;
\copy supplier FROM 'supplier.csv' DELIMITER ',' CSV;
\copy partsupp FROM 'partsupp.csv' DELIMITER …

copy create csv database encoding password schema sql template zip