TABLESPACE

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: nicolas(at)cns(dot)com(dot)cy
Subject: TABLESPACE
Date: 2022-09-04 08:00:46
Message-ID: 166227844609.1235912.8608462614653193557@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Guillaume Lelarge 2022-09-04 09:45:45 Re: TABLESPACE
Previous Message Bruce Momjian 2022-09-03 03:32:32 Re: Duplicate text in ANALYZE related to inheritance/parents