Postgres manually alter sequence

by

The parentheses are misplaced:

SELECT setval('payments_id_seq', 21, true);  -- next value will be 22

Otherwise you’re calling setval with a single argument, while it requires two or three.

This is the same as SELECT setval('payments_id_seq', 21)

More Related Contents:

  1. Safely rename tables using serial primary key columns
  2. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  3. DROP FUNCTION without knowing the number/type of parameters?
  4. PostgreSQL create table if not exists
  5. PostgreSQL: Give all permissions to a user on a PostgreSQL database
  6. Sort by column ASC, but NULL values first?
  7. Using an Alias column in the where clause in Postgresql
  8. Grouped LIMIT in PostgreSQL: show the first N rows for each group?
  9. Reset auto increment counter in postgres
  10. Optimize query with OFFSET on large table
  11. How to concatenate columns in a Postgres SELECT?
  12. Delete column from SQLite table
  13. updating table rows in postgres using subquery
  14. How can I send email from PostgreSQL trigger?
  15. Find overlapping date ranges in PostgreSQL
  16. PostgreSQL multi INSERT…RETURNING with multiple columns
  17. How do you do date math that ignores the year?
  18. Get the distinct sum of a joined table column
  19. How much disk-space is needed to store a NULL value using postgresql DB?
  20. Is it possible to run multiple DDL statements inside a transaction (within SQL Server)?
  21. Aggregate a single column in query with many columns
  22. Aggregating (x,y) coordinate point clouds in PostgreSQL
  23. PostgreSQL convert columns to rows? Transpose?
  24. Regular expression in PostgreSQL LIKE clause
  25. Postgres Error: More than one row returned by a subquery used as an expression
  26. Generate DEFAULT values in a CTE UPSERT using PostgreSQL 9.3
  27. Postgresql query between date ranges
  28. How to use SQL LIKE condition with multiple values in PostgreSQL?
  29. Drop column from SQLite table
  30. Why isn’t row level security enabled for Postgres views?

Leave a Comment