SEO

#1 (**permalink**) 04-09-2008, 10:58 AM

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
)

Thanks

Seede

#2 (**permalink**) 04-09-2008, 10:59 AM

> 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
> )

Use column type SERIAL, or, if you want to fine tune things,
use sequences:
http://www.postgresql.org/docs/8.1/s...esequence.html
(in fact, SERIAL does define a sequence behind the scenes for you).

Bye, Chris.

--

Chris Mair
http://www.1006.org

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

#3 (**permalink**) 04-09-2008, 10:59 AM

Junkone wrote:
> 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
> )

I think you'll want to remove all those double-quotes. They make your
table and column names case sensitive. You'd need to quote these in your
queries as well, if you stay with what pgadmin (apparently) created.

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
7500 AK Enschede

// Integrate Your World //

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

#4 (**permalink**) 04-09-2008, 10:59 AM

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/i...ATATYPE-SERIAL

Otherwise this also shows the long way to do it.

HTH,

Brent Wood

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

How to do auto numbering on INT column