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
