What’s the PostgreSQL datatype equivalent to MySQL AUTO INCREMENT?

by

Yes, SERIAL is the equivalent function.

CREATE TABLE foo (
    id SERIAL,
    bar varchar
);

INSERT INTO foo (bar) VALUES ('blah');
INSERT INTO foo (bar) VALUES ('blah');

SELECT * FROM foo;

+----------+
| 1 | blah |
+----------+
| 2 | blah |
+----------+

SERIAL is just a create table time macro around sequences. You can not alter SERIAL onto an existing column.

More Related Contents:

  1. How to convert primary key from integer to serial?
  2. serial in postgres is being increased even though I added on conflict do nothing
  3. How to add an auto-incrementing primary key to an existing table, in PostgreSQL?
  4. Changing primary key int type to serial
  5. postgres autoincrement not updated on explicit id inserts
  6. What is PostgreSQL equivalent to autoincrement?
  7. How do I specify a password to ‘psql’ non-interactively?
  8. INSERT with dynamic table name in trigger function
  9. psql: FATAL: Ident authentication failed for user “postgres”
  10. Run a PostgreSQL .sql file using command line arguments
  11. Where does PostgreSQL store configuration/conf files?
  12. How to thoroughly purge and reinstall postgresql on ubuntu? [closed]
  13. Creating a copy of a database in PostgreSQL
  14. PostgreSQL function returning multiple result sets
  15. How to add a new Column in a table after the 2nd or 3rd column in the Table using postgres?
  16. Can’t connect the postgreSQL with psycopg2
  17. How do you change the character encoding of a postgres database?
  18. Difference between GiST and GIN index
  19. PostgreSQL: Why psql can’t connect to server?
  20. Postgres error on insert – ERROR: invalid byte sequence for encoding “UTF8”: 0x00
  21. Can I use return value of INSERT…RETURNING in another INSERT?
  22. Changing a postgres containers server port in Docker Compose
  23. How do you find the disk size of a Postgres / PostgreSQL table and its indexes
  24. no pg_hba.conf entry for host
  25. PostgreSQL – disabling constraints
  26. PostgreSQL authentication method 10 not supported
  27. Postgres default sort by id – worldship
  28. Best way to install hstore on multiple schemas in a Postgres database?
  29. Loop through columns of RECORD
  30. How to drop PostgreSQL database through command line [closed]

Leave a Comment