Re: TABLESPACE
| От | Guillaume Lelarge |
|---|---|
| Тема | Re: TABLESPACE |
| Дата | |
| Msg-id | CAECtzeW919F0CmbgrS0DRBb_csFii9ftSnXfJJbPEMFnCedmRg@mail.gmail.com обсуждение исходный текст |
| Ответ на | TABLESPACE (PG Doc comments form <noreply@postgresql.org>) |
| Ответы |
Re: TABLESPACE
|
| Список | pgsql-docs |
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.
В списке pgsql-docs по дате отправления: