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;
ALTER TABLE IF EXISTS "DbTest"."Test"
OWNER to postgres;
What the command TABLESPACE on it's own does or how it should be used is not
documented at all
Thanks