preface,熟悉pgsql sql Language article disorder;

1,pgsql数据库控制台Cli(command line interface) help mannual;

注意\g == ; terminate with semicolon to execute query

SQL command help

psql command help

2,

postgresql基本语句