On Thu, May 03, 2001 at 11:11:20AM -0700, Terry Fielder wrote:
> Is there an autonumber data type in postgreSQL?
> 

"SERIAL"

        CREATE TABLE xxx (id SERIAL, data TEXT);

or see docs for 'create sequence' -- it's more controllable stuff.

                Karel

-- 
 Karel Zak  <[EMAIL PROTECTED]>
 http://home.zf.jcu.cz/~zakkr/
 
 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to