Yes realised just after posting Thank you very much for the response! Nicolas
On Sun, 4 Sep 2022 at 12:45, Guillaume Lelarge <guilla...@lelarge.info> wrote: > > > > 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. >
