Re: Relation wide 'LIKE' clause

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