Hello Everyone,
I have run below query it is created 'test' table without columns
but table row count is 2.
please give me clarity about this, i thought it may give syntax error but not
either it must have 2 rows data but both are not happened.
with ins_test as (select 1 as srno
union
select 2)
select into test from ins_test;
select * from test;
thank you.
Regards:
Subodh Kumar
Postgresql Developer