Re: Relation wide 'LIKE' clause

2020-06-10 Thread Georgios
‐‐‐ Original Message ‐‐‐ On Wednesday, June 10, 2020 12:08 PM, Peter Eisentraut wrote: > 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

Re: Relation wide 'LIKE' clause

2020-06-10 Thread Peter Eisentraut
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 wonderin

Relation wide 'LIKE' clause

2020-06-10 Thread Georgios
Hi, 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 s