From: | AGRE Enterprises Limited <agree(at)godzone(dot)net(dot)nz> |
---|---|
To: | pgsql-general(at)hub(dot)org |
Subject: | Default table structure |
Date: | 1999-04-21 04:05:55 |
Message-ID: | 199904210405.QAA02690@agree-2.godzone.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am making the assumption that when a table is created, it is always
a heap. Is this in fact true ?
If so, then the only way to get keyed access is through the use of an
index.
I use Ingres at work and it is great being able to change the
structure of a table so that another index isn't needed.
i.e.
create table x ( key varchar(8), value varchar(64));
modify x to btree on x;
Is something similiar possible in Postgresql, if not, are there any
plans to implement something similiar.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen Eustace, on behalf of
GodZone Internet Services, a division of AGRE Enterprises Limited
176 Te Awe Awe Street, Palmerston North, New Zealand
Ph: +64 6 356 2562, Fax: +64 6 357 0271
http://www.godzone.net.nz, EMail: agree(at)godzone(dot)net(dot)nz, ICQ: 10397208
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Bitmead | 1999-04-21 05:33:32 | Object-oriented stuff and postgres |
Previous Message | Guo Ge | 1999-04-21 02:12:34 | tracking postgres |