[GENERAL] CREATE TABLE AS

[Chairudin Sentosa Harjo]

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

************