Is there a way to use the new CREATE TABLE LIKE INCLUDING PROJECTIONS syntax to also include the data from the source table?
In this example, I'd like the beth2.table to to have the data from the beth1.table table...
Code: Select all
dbadmin=> create schema beth1;
CREATE SCHEMA
dbadmin=> create schema beth2;
CREATE SCHEMA
dbadmin=> create table beth1.table (c int);
CREATE TABLE
dbadmin=> insert into beth1.table values (1);
OUTPUT
--------
1
(1 row)
dbadmin=> commit;
COMMIT
dbadmin=> create table beth2.table like beth1.table including projections;
CREATE TABLE
dbadmin=> select * from beth2.table;
c
---
(0 rows)
Do I have to issue an insert statement? That's lame if I do!