pgAdmin 使用记录

wpadmin~May 31, 2019 /System Management

pgAdmin 使用记录



查看数据库表的 建表语句 / DDL

右键单击 表名 > Scripts > CREATE SCRIPT

查看数据库表中记录的 插入语句

Export Postgresql table data using pgAdmin

1 Right-click on your table and pick option Backup..
2 On File Options, set Filepath/Filename and pick PLAIN for Format
3 Ignore Dump Options #1 tab
4 In Dump Options #2 tab, check USE INSERT COMMANDS
5 In Dump Options #2 tab, check Use Column Inserts if you want column names in your inserts.
6 Hit Backup button

Leave a Reply

Your email address will not be published. Required fields are marked *