myleemylee的专栏

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

sudo -u postgres psql postgres=# 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