How to set auto increment primary key in PostgreSQL?

by

Try this command:

ALTER TABLE your_table ADD COLUMN key_column BIGSERIAL PRIMARY KEY;

Try it with the same DB-user as the one you have created the table.

More Related Contents:

  1. Auto increment table column
  2. Reset auto increment counter in postgres
  3. Custom SERIAL / autoincrement per group of values
  4. Serial numbers per group of rows for compound key
  5. Select rows which are not present in other table
  6. Optimize GROUP BY query to retrieve latest row per user
  7. How to implement a many-to-many relationship in PostgreSQL?
  8. Check if value exists in Postgres array
  9. How to use ANY instead of IN in a WHERE clause?
  10. Is there a shortcut for SELECT * FROM?
  11. sql statement error: “column .. does not exist”
  12. What is the difference between single quotes and double quotes in PostgreSQL?
  13. Constraint defined DEFERRABLE INITIALLY IMMEDIATE is still DEFERRED?
  14. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  15. Best way to count rows by arbitrary time intervals
  16. PostgreSQL sequence based on another column
  17. Sorting null values after all others, except special
  18. Call a set-returning function with an array argument multiple times
  19. Fastest check if row exists in PostgreSQL
  20. Discard millisecond part from timestamp
  21. Return setof record (virtual table) from function
  22. SQL Server 2005 ROW_NUMBER() without ORDER BY
  23. How do I cast a string to integer and have 0 in case of error in the cast with PostgreSQL?
  24. SQL column reference “id” is ambiguous
  25. How to use multiple CTEs in a single SQL query?
  26. IN Clause with NULL or IS NULL
  27. postgres – where in (list) – column does not exist
  28. incomplete information from query on pg_views [duplicate]
  29. Postgresql query between date ranges
  30. Why isn’t row level security enabled for Postgres views?

Leave a Comment