openGauss每日一练第14天 | 学习心得体会

导出数据

基本上和导入数据差不太多

1.练习

create database backup;
\c backup
CREATE SCHEMA ds;
create table ds.t1(id int, name char(30));
insert into ds.t1 values(1 ,'xxxx');
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 VALUES    
(6885, 1, 'Joes', 'Hunter'),    
(4321, 2, 'Lily','Carter'),    
(9527, 3, 'James', 'Cook'),
(9500, 4, 'Lucy', 'Baker');

gs_dump -f /home/omm/backup_database_all.sql backup -F p
gs_dump -f /home/omm/backup_database_data.sql backup -a -F p 
gs_dump -f /home/omm/backup_database_define.sql backup -s -F p
more /home/omm/backup_database_all.gs_dump -f 
/home/omm/backup_schema_all.sql backup -n ds -F p
sql

gs_dump -f /home/omm/backup_schema_all.sql backup -n ds -F p
gs_dump -f /home/omm/backup_schema_data.sql backup -n ds -a -F p
gs_dump -f /home/omm/backup_schema_define.sql backup -n ds -s -F p
more /home/omm/backup_schema_all.sql

gs_dump -f /home/omm/backup_table_all.sql backup -t customer_t -F p
gs_dump -f /home/omm/backup_table_data.sql backup -t customer_t -a -F p 
gs_dump -f /home/omm/backup_table_define.sql backup -t customer_t -s -F p 
more /home/omm/backup_table_all.sql

2.作业

CREATE DATABASE tpcc;
\c tpcc;
CREATE SCHEMA schema1;
CREATE TABLE schema1.products(id int);
insert into schema1.products values (generate_series(1,100));
gs_dump -f /home/omm/backup_db.sql tpcc -F p;
gs_dump -f /home/omm/backup_db2.sql tpcc -n schema1 -s -F p;
gs_dump -f /home/omm/backup_db3.sql tpcc -t schema1.products -a -F p 

DROP TABLE schema1.products;
DROP SCHEMA schema1;
DROP DATABASE tpcc;