分类：建表语句

2020
12-29

PostgreSQL标准建表语句分享

如下所示：--建表CREATETABLEifnotexistspublic.user(idcharactervarying(32)NOTNULLDEFAULTsys_guid(),namecharactervarying(100)NOTNULL,gendercharactervarying(50)NOTNULL,agecharactervarying(10)NOTNULL,id_nocharactervarying(50)NOTNULL,created_datetimestampwithouttimezoneDEFAULTnow(),created_bycharactervarying(100)DEFAULT'system',updated_datetimestampwithout... 继续阅读 >