Postgres Pro
Downloads
Home   >   mailing lists

creating table without columns - Mailing list pgsql-admin

From Subodh Kumar
Subject creating table without columns
Date
Msg-id CA+KMk93CwQBP8SMeu_wcGdrj_ZTLVQVDpL-zbCd2vdy0hfWYrw@mail.gmail.com
Whole thread Raw
Responses Re: creating table without columns  (Greg Spiegelberg <gspiegelberg@gmail.com>)
Re: creating table without columns  (Christoph Berg <myon@debian.org>)
Re: creating table without columns  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Axel Rau
Date:
Subject: Re: Getting fancy errors when accessing information_schema on 10.5
Next
From: Tom Lane
Date:
Subject: Re: Getting fancy errors when accessing information_schema on 10.5