On 09/20/2010 11:40 AM, Carlos Mennens wrote:
On Mon, Sep 20, 2010 at 10:08 AM, Thom Brown<thom@xxxxxxxxx> wrote:CREATE SEQUENCE seq_blades_id; SELECT setval('seq_blades_id', max(id)) FROM blades; -- set the sequence's value to the maximum value of "id" ALTER TABLE blades ALTER COLUMN id SET DEFAULT nextval('seq_blades_id'); -- make default value get value from sequenceThat appeared to work fine. My question that I can't find in the documentation is that if I already have one row created where my 'id = 1' for AUTO_INCREMENT, how do I enter future values into my table and force id to auto_increment rather than having me type the value into the SQL command? This way I can let PostgreSQL add the next INTEGER rather than me having to know and avoid duplicates. INSERT INTO blades VALUES ( '2', 'data', 'data', 'data', '1234', '2010-09-20 ); Is there a way I can omit having to type the '2' above in my SQL command if 'id' column is configured for AUTO_INCREMENT
INSERT INTO blades VALUES ( DEFAULT, 'data', 'data', 'data', '1234', '2010-09-20 ); -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
