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