Le dim. 4 sept. 2022, 10:19, PG Doc comments form <nore...@postgresql.org> a écrit :
> The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/14/sql-createtablespace.html > Description: > > When exporting a table create script pgAdmin includes a command "TABLESPACE > pg_default;" such as below > > CREATE TABLE IF NOT EXISTS "DbTest"."Test" > ( > "TestID" integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 > START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ), > "TestName" character varying(80) COLLATE pg_catalog."default" NOT > NULL, > "CreateTimestamp" timestamp without time zone NOT NULL DEFAULT > LOCALTIMESTAMP, > "UpdateTimestamp" timestamp without time zone NOT NULL DEFAULT > LOCALTIMESTAMP, > CONSTRAINT "Test_pk" PRIMARY KEY ("TestID"), > ) > > TABLESPACE pg_default; > As you can see, there's no ";" between ")" and "TABLESPACE", so it's not a command on its own but another clause of the CREATE TABLE statement. It indicates the tablespace for the new table.
