On 10/02/2026 12:52, Marcos Pegoraro wrote: > I think the approach will fail at some point if you keep using CREATE > TABLE LIKE, because so many things will be incomplete or at least > strange, that you'll have to redo many of them. > Sequencevalues will be shared with the old table. > Constraints/Indexes names will have to be renamed. > Partitioned tables will have to be attached. > Foreign Keys are not created either. Quite right. Either we draw a clear line here, or it will be a tough nut to crack. Best, Jim
- Add CREATE SCHEMA ... LIKE support David G. Johnston
- Re: Add CREATE SCHEMA ... LIKE support Matheus Alcantara
- Re: Add CREATE SCHEMA ... LIKE support Matheus Alcantara
- Re: Add CREATE SCHEMA ... LIKE support Marcos Pegoraro
- Re: Add CREATE SCHEMA ... LIKE support Marcos Pegoraro
- Re: Add CREATE SCHEMA ... LIKE sup... Matheus Alcantara
- Re: Add CREATE SCHEMA ... LIKE support Matheus Alcantara
- Re: Add CREATE SCHEMA ... LIKE sup... Jim Jones
- Re: Add CREATE SCHEMA ... LIKE... Jim Jones
- Re: Add CREATE SCHEMA ... LIKE... Marcos Pegoraro
- Re: Add CREATE SCHEMA ... LIKE... Jim Jones
- Re: Add CREATE SCHEMA ... LIKE... Matheus Alcantara
- Re: Add CREATE SCHEMA ... LIKE... David G. Johnston
- Re: Add CREATE SCHEMA ... LIKE... Matheus Alcantara
- Re: Add CREATE SCHEMA ... LIKE... Jim Jones
- Re: Add CREATE SCHEMA ... LIKE... Matheus Alcantara
- Re: Add CREATE SCHEMA ... LIKE... Jim Jones
- Re: Add CREATE SCHEMA ... LIKE... Marcos Pegoraro
- Re: Add CREATE SCHEMA ... LIKE... Matheus Alcantara
- Re: Add CREATE SCHEMA ... LIKE... Jim Jones
- Re: Add CREATE SCHEMA ... LIKE support Álvaro Herrera
