Junkone wrote:
HI
I have a simple table created using PGAdmin III. How do i do a auto
numbering on a column SYMBOL_ID?
My table is
CREATE TABLE "SYMBOL"
(
"SYMBOL_ID" int4 NOT NULL,
"SYMBOL2EXCHANGE" int2 NOT NULL,
"SYMBOL_ALIAS" text[],
"RELATED_SYMBOLS_OTHER_EXCHANGES" int8[],
"SYMBOL_NAME" text,
"COMPANY_NAME" text,
"SYMBOL2SECTOR" int2,
"SYMBOL2INDUSTRY" int4,
"STOCK_SUMMARY" text
)
If you can, the easy way is to recreate the table using a serial
datatype instead of int4.
See the docs at
http://www.postgresql.org/docs/8.1/interactive/datatype.html#DATATYPE-SERIAL
Otherwise this also shows the long way to do it.
HTH,
Brent Wood
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
