On Tuesday 21 June 2005 13:01, you wrote: > hi, > in a table with a serial datatype, how do i get the sequence to start > at a specific number like 100000?
ALTER SEQUENCE sequence_name RESTART WITH 100000; -- ________________________________________________________ Krasimir Dimitrov IT Department AII Data Processing Ltd., 16 Ivan Vazov Str, Sofia 1000, Bulgaria Phone: +359 2 9376 352 E-mail: [EMAIL PROTECTED] http://www.see-news.com ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
