导出
pg_dump -U [username] -h [host] -p [port] -t [tablename] -f /tmp/file.sql [database]
导入
D:\Program Files (x86)\PostgreSQL\9.5\bin>psql.exe -U postgres -f in.sql dbname
导出
pg_dump -U [username] -h [host] -p [port] -t [tablename] -f /tmp/file.sql [database]
导入
D:\Program Files (x86)\PostgreSQL\9.5\bin>psql.exe -U postgres -f in.sql dbname
本文标题:pg导出导入copy格式的数据
本文链接:https://www.haomeiwen.com/subject/rlltchtx.html
网友评论