Re: [GENERAL] CREATE TABLE LIKE including all not including storage parameters? - Mailing list pgsql-general

From Michael Paquier
Subject Re: [GENERAL] CREATE TABLE LIKE including all not including storage parameters?
Date
Msg-id CAB7nPqSpHbpJSoZ3mB=Bj_Jji+Hjgk1tiS69DFbZ=OY+HpuvwA@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] CREATE TABLE LIKE including all not including storageparameters?  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: [GENERAL] CREATE TABLE LIKE including all not including storageparameters?  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-general
On Tue, Sep 5, 2017 at 6:45 PM, Achilleas Mantzios
<achill@matrix.gatewaynet.com> wrote:
> Am I doing something wrong here?

From the documentation:
https://www.postgresql.org/docs/devel/static/sql-createtable.html
STORAGE settings for the copied column definitions will be copied only
if INCLUDING STORAGE is specified. The default behavior is to exclude
STORAGE settings, resulting in the copied columns in the new table
having type-specific default settings. For more on STORAGE settings,
see Section 66.2.

And in this case storage parameters refer to column-specific settings,
not table-level storage parameters, which are defined here by toast:
https://www.postgresql.org/docs/devel/static/storage-toast.html
--
Michael


pgsql-general by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: [GENERAL] CREATE TABLE LIKE including all not including storageparameters?
Next
From: Achilleas Mantzios
Date:
Subject: Re: [GENERAL] CREATE TABLE LIKE including all not including storageparameters?