MIME-Version: 1.0
References: <166227844609.1235912.8608462614653193557@wrigleys.postgresql.org>
In-Reply-To: 
 <166227844609.1235912.8608462614653193557@wrigleys.postgresql.org>
From: Guillaume Lelarge <guillaume@lelarge.info>
Date: Sun, 4 Sep 2022 11:45:45 +0200
Message-ID: 
 <CAECtzeW919F0CmbgrS0DRBb_csFii9ftSnXfJJbPEMFnCedmRg@mail.gmail.com>
Subject: Re: TABLESPACE
To: nicolas@cns.com.cy, pgsql-docs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000008b235c05e7d6d466"
Archived-At: 
 <https://www.postgresql.org/message-id/CAECtzeW919F0CmbgrS0DRBb_csFii9ftSnXfJJbPEMFnCedmRg%40mail.gmail.com>
Precedence: bulk

--0000000000008b235c05e7d6d466
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Le dim. 4 sept. 2022, 10:19, PG Doc comments form <noreply@postgresql.org>
a =C3=A9crit :

> 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 "TABLESPA=
CE
> 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.

--0000000000008b235c05e7d6d466
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div><br><div data-smartmail=3D"gmail_signature"><br></di=
v><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">Le d=
im. 4 sept. 2022, 10:19, PG Doc comments form &lt;<a href=3D"mailto:noreply=
@postgresql.org">noreply@postgresql.org</a>&gt; a =C3=A9crit=C2=A0:<br></di=
v><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:=
1px #ccc solid;padding-left:1ex">The following documentation comment has be=
en logged on the website:<br>
<br>
Page: <a href=3D"https://www.postgresql.org/docs/14/sql-createtablespace.ht=
ml" rel=3D"noreferrer noreferrer" target=3D"_blank">https://www.postgresql.=
org/docs/14/sql-createtablespace.html</a><br>
Description:<br>
<br>
When exporting a table create script pgAdmin includes a command &quot;TABLE=
SPACE<br>
pg_default;&quot; such as below<br>
<br>
CREATE TABLE IF NOT EXISTS &quot;DbTest&quot;.&quot;Test&quot;<br>
(<br>
=C2=A0 =C2=A0 &quot;TestID&quot; integer NOT NULL GENERATED ALWAYS AS IDENT=
ITY ( INCREMENT 1<br>
START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),<br>
=C2=A0 =C2=A0 &quot;TestName&quot; character varying(80) COLLATE pg_catalog=
.&quot;default&quot; NOT<br>
NULL,<br>
=C2=A0 =C2=A0 &quot;CreateTimestamp&quot; timestamp without time zone NOT N=
ULL DEFAULT<br>
LOCALTIMESTAMP,<br>
=C2=A0 =C2=A0 &quot;UpdateTimestamp&quot; timestamp without time zone NOT N=
ULL DEFAULT<br>
LOCALTIMESTAMP,<br>
=C2=A0 =C2=A0 CONSTRAINT &quot;Test_pk&quot; PRIMARY KEY (&quot;TestID&quot=
;),<br>
)<br>
<br>
TABLESPACE pg_default;<br></blockquote></div></div><div dir=3D"auto"><br></=
div><div dir=3D"auto">As you can see, there&#39;s no &quot;;&quot; between =
&quot;)&quot; and &quot;TABLESPACE&quot;, so it&#39;s not a command on its =
own but another clause of the CREATE TABLE statement. It indicates the tabl=
espace for the new table.</div></div>

--0000000000008b235c05e7d6d466--