Hi Richard,
I am using postgres 8.0.1. It allows us to create TABLESPACE but I don't know how to create PARTITION in postgres.
Can you pls tell me little more.
You can't I'm afraid. You can use inheritance / a view unioning tables to do something similar though. Check the mailing-list archives for notes on these.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq