Hi,
How do I create a table from a 'select' statement?
I tried the help from psql '\h create table',
it does not explain how.
I tried:
create table blah2 as
select pin from tbs_billing_record
where date(start_time) between '01-JAN-2000' and '23-JAN-2000'
order by pin;
I received error saying:
ERROR: parser: parse error at or near "order"
Why is that?
Could someone help me please?
Regards,
Chai