TABLESPACE

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: