pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedTABLESPACE
3+ messages / 3 participants
[nested] [flat]
* TABLESPACE
@ 2022-09-04 08:00 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: PG Doc comments form @ 2022-09-04 08:00 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: nicolas@cns.com.cy
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: TABLESPACE
@ 2022-09-04 09:45 Guillaume Lelarge <guillaume@lelarge.info>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: Guillaume Lelarge @ 2022-09-04 09:45 UTC (permalink / raw)
To: nicolas@cns.com.cy; pgsql-docs@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: TABLESPACE
@ 2022-09-04 11:27 Nicolas Shiacolas <nicolas@cns.com.cy>
parent: Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 0 replies; 3+ messages in thread
From: Nicolas Shiacolas @ 2022-09-04 11:27 UTC (permalink / raw)
To: Guillaume Lelarge <guillaume@lelarge.info>; +Cc: pgsql-docs@lists.postgresql.org
Yes realised just after posting
Thank you very much for the response!
Nicolas
On Sun, 4 Sep 2022 at 12:45, Guillaume Lelarge <guillaume@lelarge.info>
wrote:
>
>
>
> 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.
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2022-09-04 11:27 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-09-04 08:00 TABLESPACE PG Doc comments form <noreply@postgresql.org>
2022-09-04 09:45 ` Guillaume Lelarge <guillaume@lelarge.info>
2022-09-04 11:27 ` Nicolas Shiacolas <nicolas@cns.com.cy>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox