Cannot create a database table named ‘user’ in PostgreSQL

by

user is a reserved word and it’s usually not a good idea use reserved words for identifiers (tables, columns).

If you insist on doing that you have to put the table name in double quotes:

create table "user" (...);

But then you always need to use double quotes when referencing the table. Additionally the table name is then case-sensitive. "user" is a different table name than "User".

If you want to save yourself a lot of trouble use a different name. users, user_account, …

More details on quoted identifiers can be found in the manual: http://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS

More Related Contents:

  1. PostgreSQL Error: Relation already exists
  2. Is it possible to have autoincrement number without it being an ID?
  3. Maximum characters in labels (table names, columns etc)
  4. How to work with PGpoint for Geolocation using PostgreSQL?
  5. JPA and PostgreSQL with GenerationType.IDENTITY
  6. PostgreSQL: Show tables in PostgreSQL
  7. PostgreSQL “DESCRIBE TABLE”
  8. What’s the fastest way to do a bulk insert into Postgres?
  9. Making sense of Postgres row sizes
  10. What’s the PostgreSQL datatype equivalent to MySQL AUTO INCREMENT?
  11. Permission denied for relation
  12. Postgresql UUID supported by Hibernate?
  13. How to configure PostgreSQL to accept all incoming connections
  14. Postgresql : Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections [duplicate]
  15. Disable PostgreSQL foreign key checks for migrations
  16. Prevent recursive trigger in PostgreSQL
  17. Spark Dataframes UPSERT to Postgres Table
  18. How to make a select with array contains value clause in psql
  19. Using row_to_json() with nested joins
  20. Optimize Postgres query on timestamp range
  21. Use variable set by psql meta-command inside of DO block
  22. pgAdmin III Why query results are shortened?
  23. How do I handle opening/closing Db connection in a Go app?
  24. How do I alter the date format in Postgres?
  25. OpenShift: How to connect to postgresql from my PC
  26. clojure.java.jdbc lazy query
  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