Does postgresql support storage clause when creating tables

Hi:

A postgresql newbie question. First a little background here, I just started
working on postgresql yesterday. We have an oracle database running and we
are planning to support it on postgresql platform too. I installed
postgres703 on our RedHat linux 7.0 box and was able to create a "testdb"
and use "psql" to "play" a bit. Now I would like to create the same tables
that we have in the oracle db. For example, in oracle I would issue:

CREATE TABLE HpxNewBrand(
BrandID NUMBER(9, 0) NOT NULL,
VendorName VARCHAR2(40),
ReBrand VARCHAR2(44),
CONSTRAINT PKHpxNewBrand PRIMARY KEY (BrandID)
USING INDEX TABLESPACE INDX
STORAGE(INITIAL 50K
NEXT 25K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
)
)
TABLESPACE DATA
STORAGE(INITIAL 500K
NEXT 500K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
);

because in oracle I can separate table and index into different
"tablespace". And I can also specify storage clause for disk space
allocation.

How do I do this in postgresql in the following command?

CREATE TABLE HpxNewBrand(
BrandID NUMBER(9, 0) NOT NULL,
VendorName VARCHAR2(40),
ReBrand VARCHAR2(44),
CONSTRAINT PKHpxNewBrand PRIMARY KEY (BrandID);

I looked at User's Guide, it seems that postgres does not support "storage
clause". How do I allocate a "big block" to store my data?

I have another table that have 0.25 million records and they don't change
often. I want to allocate one big "extent" so that there will not be
"de-fragmentation" on the disk. How could I do that?

TIA

Guang

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com