是这个意思:在pgAdmin III新建表,输入的表名为TestTable,完成后,它自动生成的SQL:
-- Table: "TestTable"-- DROP TABLE "TestTable";CREATE TABLE "TestTable"
(
aaa char(5)
)
WITHOUT OIDS;
ALTER TABLE "TestTable" OWNER TO postgres;即是表名带双引号的,我在程序中Select时也必须对表名加双引号
-- Table: "TestTable"-- DROP TABLE "TestTable";CREATE TABLE "TestTable"
(
aaa char(5)
)
WITHOUT OIDS;
ALTER TABLE "TestTable" OWNER TO postgres;即是表名带双引号的,我在程序中Select时也必须对表名加双引号
-- Table: reason-- DROP TABLE reason;CREATE TABLE reason
(
"Code" varchar(3) NOT NULL,
"Name" varchar(20) NOT NULL,
CONSTRAINT "PK_reason" PRIMARY KEY ("Code")
)
WITHOUT OIDS;
ALTER TABLE reason OWNER TO postgres;
GRANT ALL ON TABLE reason TO postgres;从上面看出,不光是表名,列名、约束名也是这样的