On 2020-06-10 11:42, Georgios wrote:
> Postgres create table statement supports `LIKE source_table [like_option... ]`
> to specify `a table from which the new table automatically copies all column
> names, their data types, and their not-null constraints.` according to
> documentation [1].
>
> I am wondering if a similar clause would make sense to copy relation wide
> settings. For example consider a relation created like this:
>
> `CREATE TABLE source_table ([column, ...]) USING customam WITH (storage_parameter1 = value1, ... )`
We already have LIKE INCLUDING STORAGE. Maybe that should just be
updated to work like what you are asking for.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services