Postgresql: How can I duplicate a table with its default values on columns?

Question

Is it even possible to copy a structure from a table without data but with the columns definitions specially like defaults and nullable values ?

This is not working:

select * 
into new_ledger_table 
from details_table 
where 1 = 2;

Note that select ... into to create a new table is discouraged (even deprecated) in favor of the standard compliant create table .. as select ... — user330315
– user330315, Commented Dec 5, 2020 at 20:08

score 3 · Accepted Answer · 2020-12-05 20:09:13Z

3

Yes, that's what create table (like ..) is for:

create table new_ledger_table (like details_table including defaults)

The including part has more options to optionally include constraints and indexes.

answered Dec 5, 2020 at 20:07

user330315

Sign up to request clarification or add additional context in comments.

1 Comment

I'll try out and let you know. Thanks.