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:
Simon Drabble wrote:
>
> On Thu, 14 Oct 1999, Chairudin Sentosa Harjo wrote:
>
> > Dear all,
> >
> > mydb=> create table rtext (rtext varchar(10));
> > CREATE
> > mydb=> insert into rtext values ('hello');
> > INSERT 17681 1
> >
Dear all,
mydb=> create table rtext (rtext varchar(10));
CREATE
mydb=> insert into rtext values ('hello');
INSERT 17681 1
What do "17681" and "1" mean?
Could someone help me to understand this please?
Regards,
Chai
