myleemylee的专栏

转载自：phyeas的博客 http://www.iteye.com/topic/375776#简单查询 print(session.query(User).all()) print(session.query(User.name, User.fullname).

sudo -u postgres psqlpostgres=# create role username login;postgres=# create database databasename owner username;然后修改/etc/postgresql/

1. 添加唯一性约束alter table table_name add constraint constraint_name unique(column_name);2.添加外建约束alter table table_name add constraint constraint_name FOREIGN KEY (table_name_id) REFERENCES table_for