Re: TABLESPACE

Yes realised just after posting
Thank you very much for the response!
Nicolas

On Sun, 4 Sep 2022 at 12:45, Guillaume Lelarge <guillaume(at)lelarge(dot)info>
wrote:

>
>
>
> 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.
>