Re: Temp rows - is it possible?

When grilled further on (Tue, 11 Nov 2003 11:39:02 +0530),
Shridhar Daithankar <shridhar_daithankar@myrealbox.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