postgresql sequence nextval in schema

Question

I have a sequence on postgresql 9 3 inside a schema  I can do this  SELECT last value  increment by from foo  quot SQ ID quot     last value   increment by ------------ --------------           1              1  1 fila   But this doesn t work  SELECT nextval  foo SQ ID     ERROR   no existe la relaci  n   foo sq id   L  NEA 1  SELECT nextval  foo SQ ID     What is wrong   It says that  not exist the relation foo sq id  but it exists

User · Answer

SELECT last value  increment by from  other schema  id seq    for adding a seq to a column where the schema is not public try this   nextval   other schema  id seq   regclass

User · Answer

The quoting rules are painful  I think you want   SELECT nextval  foo  SQ ID       to prevent case-folding of SQ ID

[postgresql] postgresql sequence nextval in schema

Examples related to postgresql

Examples related to postgresql-9.3