Thread: TABLESPACE
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
Le dim. 4 sept. 2022, 10:19, PG Doc comments form <noreply@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.
Yes realised just after posting
Thank you very much for the response!
Nicolas
On Sun, 4 Sep 2022 at 12:45, Guillaume Lelarge <guillaume@lelarge.info> wrote:
Le dim. 4 sept. 2022, 10:19, PG Doc comments form <noreply@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.