Re: Temp rows - is it possible?

When grilled further on (Tue, 11 Nov 2003 11:39:02 +0530),
Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com> confessed:

> > them). Would there be an alternate method to easily create a temp table
> > that is identical to another?
>
> You can use LIKE clause in create table.
>
> See http://developer.postgresql.org/docs/postgres/sql-createtable.html
>

Thanks Shridhar,

I didn't know there was a LIKE clause, and it's even right above INHERITS in
the docs... I also didn't realize that the parent table would see all the
child tables data when using INHERITS. I should be using LIKE...

Cheers,
Rob

--
09:58:11 up 102 days, 3:16, 5 users, load average: 1.05, 1.11, 1.41