Answer the question
In order to leave comments, you need to log in
How to add nextval to postgresql column?
I have a DNS schema and an objSklad table, it has an id_sklad column. There is also a sequence objSklad_id_sklad_seq that is bound to id_sklad. I have, when filling out the table
INSERT INTO "DNS"."objSklad" (city, region)
VALUES ('Omsk', 'OmskObl');
INSERT INTO "DNS"."objSklad" (id_sklad, city, region)
VALUES (nextval('"DNS"."objSklad_id_sklad_seq"'), 'Omsk', 'OmskObl');
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question