From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | nicolas(at)cns(dot)com(dot)cy, pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | Re: TABLESPACE |
Date: | 2022-09-04 09:45:45 |
Message-ID: | CAECtzeW919F0CmbgrS0DRBb_csFii9ftSnXfJJbPEMFnCedmRg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
Le dim. 4 sept. 2022, 10:19, PG Doc comments form <noreply(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Nicolas Shiacolas | 2022-09-04 11:27:57 | Re: TABLESPACE |
Previous Message | PG Doc comments form | 2022-09-04 08:00:46 | TABLESPACE |