gbPv3p4X

1CREATE TABLE IF NOT EXISTS t(
2    id serial PRIMARY KEY,
3    value text
4);
5INSERT INTO t(id,value) VALUES (1,'value1'), (2,'value2');
6
7CREATE TABLE t_with_data AS TABLE t;
8CREATE TABLE t_without_data AS TABLE t WITH NO DATA;
9
10select COUNT(*) from t_without_data;
11select COUNT(*) from t_with_data;