6、openguass 导入导出.docx

是赐赐啊！🦄

104

28页

2次

2024-07-22

10墨值下载

openguass 导入导出

一、表级 COPY 命令

1.1 功能描述

通过 COPY 命令实现在表和文件之间拷贝数据。

COPY FROM 从一个文件拷贝数据到一个表，COPY TO 把一个表的数据拷贝到一个

文件。

该命令导出方式，兼容各种数据库。

1.2 操作示例

1.2.1、导出

将 sbtest1 表中的数据拷贝到/home/omm/dir_dw 文件中。

先创建目录

[omm@eb62246 ~]$ mkdir -p /home/omm/dir_dw

1.2.1.1、通过超级用户 omm 执行 copy 导出

[omm@eb62246 ~]$ gsql -p 15400 -W 1cmszx#YZSSY -r -U omm -d yxfdb

gsql ((openGauss 5.0.0 build a07d57c3) compiled at 2023-03-29

03:37:13 commit 0 last mr )

Non-SSL connection (SSL connection is recommended when requiring

high-security)

Type "help" for help.

yxfdb=# select * from sbtest1 ;

id | k |

c |

pad

----+---

+----------------------------------------------------------------

----------------------------------------------------------

+----------

----------------------------------------------------

1 | 2 | 31451373586-15688153734-79729593694-96509299839-

83724898275-86711833539-78981337422-35049690573-51724173961-

87474696253 | 989966216

24-36689827414-04092488557-09587706818-65008859162

2 | 2 | 21472970079-70972780322-70018558993-71769650003-

09270326047-32417012031-10768856803-14235120402-93989080412-

18690312264 | 047768266

83-45880822084-77922711547-29057964468-76514263618

3 | 2 | 49376827441-24903985029-56844662308-79012577859-

40518387141-60588419212-24399130405-42612257832-29494881732-

71506024440 | 268430358

07-96849339132-53943793991-69741192222-48634174017

4 | 1 | 85762858421-36258200885-10758669419-44272723583-

12529521893-95630803635-53907705724-07005352902-43001596772-

53048338959 | 379794242

84-37912826784-31868864947-42903702727-96097885121

5 | 1 | 39629182538-02480546617-58524552861-79463588264-

94630521692-52863783258-10322448958-16888371172-79549156168-

39196968147 | 212022277

77-41928895955-25555646807-61419229042-65545767251

(5 rows)

yxfdb=# COPY sbtest1 TO '/home/omm/dir_dw/sbtest1.dat' using

delimiters '|';

COPY 5

##XXX.dat 文件后缀可以自命名，如 dat、unl 等

1.2.1.2、采用普通用户执行 copy 导出时

[omm@eb62246 ~]$ gsql -p 15400 -W 1cmszx#YZSSY -r -U yxf -d yxfdb

gsql ((openGauss 5.0.0 build a07d57c3) compiled at 2023-03-29

03:37:13 commit 0 last mr )

Non-SSL connection (SSL connection is recommended when requiring

high-security)

Type "help" for help.

yxfdb=> select * from sbtest2 ;

id | k |

c |

pad

----+---

+----------------------------------------------------------------

----------------------------------------------------------

+----------

----------------------------------------------------

1 | 5 | 43033802100-77764610845-39799112869-39522082157-

29991343351-03104546403-44218055411-44753886367-06713013651-

11339959167 | 959800757

36-25797396575-06969310132-10655251718-72185519249

2 | 5 | 76306723138-65475533272-75387439533-24814990765-

46240013424-33025575802-49383130113-39076862901-68733582344-

28627130698 | 967302613

34-40420286195-59727642680-29068251337-21208591100

3 | 1 | 95511505952-67827527851-32245183764-01321888676-

12935581940-38116431620-03035069779-75393323033-78637090354-

of 28

10墨值下载

opengauss

关注

评论