How to partition the table, week-wise? I have a table with hundreds of thousands of records. How to partition the table, week-wise?

A few million rows insertion will be taking place in my table in a day.So i need to partition it weekly. There is a datetime column which I want to partition by weekly
First of all what kind of database are you using? And are you referring to table partitioning?

Anyways for Oracle, please see this link..

https://forums.oracle.com/forums/thread.jspa?threadID=879608

I'm not too sure about how this would be done in PostgreSQL, but I think partitioning is much less relevant for PostgreSQL rather than for Oracle