copy语法 postgre_postgresql copy文件报错。。

本帖最后由 tanfeng3 于 2010-12-13 12:48 编辑

copy to/from 文件时需要 superuser的权限，

如果普通用户需要用到COPY命令，可以采用以下方式

1 copy to stdout

2 copy from stdin

--copy 语法如下

db_lbs=# \h copy

Command:     COPY

Description: copy data between a file and a table

Syntax:

COPY tablename [ ( column [, ...] ) ]

FROM { 'filename' | STDIN }

[ [ WITH ]

[ BINARY ]

[ OIDS ]

[ DELIMITER [ AS ] 'delimiter' ]

[ NULL [ AS ] 'null string' ]

[ CSV [ HEADER ]

[ QUOTE [ AS ] 'quote' ]

[ ESCAPE [ AS ] 'escape' ]

[ FORCE NOT NULL column [, ...] ]

COPY { tablename [ ( column [, ...] ) ] | ( query ) }

TO { 'filename' | STDOUT }

[ [ WITH ]

[ BINARY ]

[ OIDS ]

[ DELIMITER [ AS ] 'delimiter' ]

[ NULL [ AS ] 'null string' ]

[ CSV [ HEADER ]

[ QUOTE [ AS ] 'quote' ]

[ ESCAPE [ AS ] 'escape' ]

[ FORCE QUOTE column [, ...] ]

作者: tanfeng3

发布时间: 2010-12-13