Re: CREATE TABLE LIKE including all not including storage parameters?

On 05/09/2017 13:26, Michael Paquier wrote:
> On Tue, Sep 5, 2017 at 6:45 PM, Achilleas Mantzios
> <achill(at)matrix(dot)gatewaynet(dot)com> wrote:
>> Am I doing something wrong here?
I didn't sat that :) but you are right, STORAGE settings for copied col defs != tables's storage parameters. The key here is that LIKE deals with columns only, not other parameters of the table.
> 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

--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt