PostgreSQL Common Technology Set

PostgreSQL Add a self-increment constraint

ALTER TABLE table_name ALTER COLUMN COLUMN_NAME SET default Nextval (' Seq_name ');

If you need to build a seq_name sequence,

How does the trigger function of PostgreSQL debug?

Self-addressed, equipped with debugger

can PostgreSQL insert multiple tables at the same time?
Open transaction

postgresql first determine if the field already exists in the table, does not exist then add?
Modify TABLE Structure statement: ALTER TABLE T_ZXXS_AJ add column C_bh VARCHAR
To determine if this field exists in the table: SELECT COUNT (*) from Information_ Schema.columns WHERE table_name = ' t_zxxs_aj ' and column_name= ' C_ah '
I wonder if I could combine it with case?

PostgreSQL Common Technology Set