本文主要是介绍postgresql表的数据导入导出,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
命令行链接pgsql
pg_test=# \h copy
Command: COPY
Description: copy data between a file and a table
Syntax:
COPY table_name [ ( column_name [, ...] ) ]FROM { 'filename' | PROGRAM 'command' | STDIN }[ [ WITH ] ( option [, ...] ) ]COPY { table_name [ ( column_name [, ...] ) ] | ( query ) }TO { 'filename' | PROGRAM 'command' | STDOUT }[ [ WITH ] ( option [, ...] ) ]where option can be one of:FORMAT format_nameOIDS [ boolean ]FREEZE [ boolean ]DELIMITER 'delimiter_character'NULL 'null_string'HEADER [ boolean ]QUOTE 'quote_character'ESCAPE 'escape_character'FORCE_QUOTE { ( column_name [, ...] ) | * }FORCE_NOT_NULL ( column_name [, ...] )FORCE_NULL ( column_name [, ...] )ENCODING 'encoding_name'
导入示例1:
\copy test.student_info(id, username) from stu_info.csv with DELIMITER ','
导出示例1:
\copy (select id,username from test.student_info where username != '') to stu_info.csv with delimiter ',' csv header
这篇关于postgresql表的数据导入导出的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!