Re: TABLESPACE

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

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: TABLESPACE
Следующее
От: Nicolas Shiacolas
Дата:
Сообщение: Re: TABLESPACE