postgresql sql create table

概述postgresql create table: BEGIN;CREATE TABLE t1 ( id BIGSERIAL PRIMARY KEY, address INTERGER DEFAULT '', name VARCHAR UNIQUE NOT NULL, did VARCHAR, count INTERGER NOT NULL, money DOUBLE PRECI

postgresql create table:

BEGIN;CREATE table t1 (	ID		BIGSERIAL PRIMARY KEY,address	INTERGER DEFAulT '',name	VARCHAR UNIQUE NOT NulL,dID		VARCHAR,count	INTERGER NOT NulL,money	DOUBLE PRECISION NOT NulL DEFAulT 0,CONSTRAINT money_check (money >= 0),ratio	REAL NOT NulL DEFAulT 0,tm		TIMESTAMP,pass	BOolEAN NOT NulL DEFAulT FALSE,);CREATE table t2 (	p_ID		BITINT NOT NulL,ticket_ID	BITINT NOT NulL,"type"		VARCHAR NOT NulL,PRIMARY KEY (p_ID,ticket_ID));CREATE INDEX ticket_player ON t2(p_ID);COMMIT;

总结

以上是内存溢出为你收集整理的postgresql sql create table全部内容，希望文章能够帮你解决postgresql sql create table所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。