如何将CSV文件导入到PostgreSQL呢 RT。PostgreSQL版本为 8.4 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 mydb=# \h copyCommand: COPYDescription: copy data between a file and a tableSyntax: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 [, ...] ] 参考http://www.pgsqldb.org/pgsqldoc-8.1c/sql-copy.html thanks 不过有一问题 对于参数 filename 比如 我放在 D盘下有个文件名字叫oui.csv那么我在写的时候 是不是应该是 'D:\oui.csv' 这么写呢?但是它提示写法不正确 要这么写 D'\\r\\n' 我写了还是不可以,在呢么回事儿。 模糊查询的速度优化 一个sql排序问题 用MySQL做集群时的一个异常 将mysql中查询出来的数据分段发送? vc+mysql, 如何插入100万条记录?求实例代码 提交中文到数据库产生乱码 求教各位高手,那里有mysql管理器?如何使用? sql文件中如何编写循环建表的脚本? update执行效率问题 怎样制作一个可以运行两个安装程序的安装文件? MySql在Windows的并发测试工具? 关于MYSQL语法的问题,请教!!!!
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 [, ...] ]
http://www.pgsqldb.org/pgsqldoc-8.1c/sql-copy.html
对于参数 filename 比如 我放在 D盘下有个文件名字叫oui.csv
那么我在写的时候 是不是应该是 'D:\oui.csv' 这么写呢?但是它提示
写法不正确 要这么写 D'\\r\\n' 我写了还是不可以,在呢么回事儿。