Neurohazard
暮雲煙月,皓首窮經;森羅萬象,如是我聞。

pgAdmin 使用记录

wpadmin~May 31, 2019 /System Management

pgAdmin 使用记录

记录一些常用的使用场景

基本使用
http://127.0.0.1:35482/browser/

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

右键单击 表名 > Scripts > CREATE SCRIPT

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

Export Postgresql table data using pgAdmin
https://stackoverflow.com/questions/11257132/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 *

This site uses Akismet to reduce spam. Learn how your comment data is processed.