From: | Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com> |
---|---|
To: | PostgreSQL Mailing List <pgsql-novice(at)postgresql(dot)org> |
Subject: | Some questions on KEYS |
Date: | 2002-11-08 07:25:18 |
Message-ID: | 20021108072518.92171.qmail@web80304.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi :
In the PostgreSQL 7.2.1 SQL Reference manual I
encountered the following syntax under the "ALTER
TABLE" section.
ALTER TABLE table
ADD <table constraint definition>
ALTER TABLE [ ONLY ] table [ * ]
ADD [ COLUMN ] <column> <type> [
<column_constraint> [ ... ] ]
1) Is <table constraint definition> similar to
<column_constraint>?
2) Is the column <column_constaint> in ALTER TABLE the
same the <column_constraint> found under the section
"CREATE TABLE" ?
3) If a table w/ primary doesn't have any index. Does
it perform a sequential scan on the key columns before
inserting a new record?
4) If primary keys utilizes index, is a multi-column
index on multi-columned key a better implementation
over creating a seperate index for each column in the
primary key?
Thank you in advance,
ludwig
__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-11-08 07:29:23 | Re: Use of nextval, currval |
Previous Message | Josh Berkus | 2002-11-08 00:53:32 | Re: Use of nextval, currval |