Postgres table column name restrictions?

by

Here’s a nice table of reserved words in PostgreSQL:
http://www.postgresql.org/docs/current/static/sql-keywords-appendix.html

It is probably best to simply avoid using those words as table- or column-names.
An alternative, however, is to enclose the identifier in double-quotes, e.g.:

CREATE TABLE IF NOT EXISTS apiss (
    skey TEXT, 
    time INTEGER, 
    "user" TEXT, 
    ip TEXT);

Additionally, Postgres reserves system column names for internal use in every table:
“Every table has several system columns that are implicitly defined by the system. Therefore, these names cannot be used as names of user-defined columns.”

https://www.postgresql.org/docs/current/ddl-system-columns.html

More Related Contents:

  1. PostgreSQL Error: Relation already exists
  2. How to reset postgres’ primary key sequence when it falls out of sync?
  3. How to import CSV file data into a PostgreSQL table
  4. Calculating and saving space in PostgreSQL
  5. The forgotten assignment operator “=” and the commonplace “:=”
  6. Equivalent to unpivot() in PostgreSQL
  7. Passing user id to PostgreSQL triggers
  8. PostgreSQL: ERROR: 42601: a column definition list is required for functions returning “record”
  9. Do nullable columns occupy additional space in PostgreSQL?
  10. How do I efficiently select the previous non-null value?
  11. Postgresql : Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections [duplicate]
  12. Disable PostgreSQL foreign key checks for migrations
  13. Prevent recursive trigger in PostgreSQL
  14. serial in postgres is being increased even though I added on conflict do nothing
  15. Can’t connect to Postgresql on port 5432
  16. How to make a select with array contains value clause in psql
  17. Using row_to_json() with nested joins
  18. PostgreSQL create table if not exists
  19. Sorting array elements
  20. pgAdmin III Why query results are shortened?
  21. How do I alter the date format in Postgres?
  22. OpenShift: How to connect to postgresql from my PC
  23. clojure.java.jdbc lazy query
  24. PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values
  25. input file appears to be a text format dump. Please use psql
  26. Destroying a Postgres DB on Heroku
  27. Is it possible to change the natural order of columns in Postgres?
  28. ERROR: could not stat file “XX.csv”: Unknown error
  29. SELECT or INSERT a row in one command
  30. Selecting rows ordered by some column and distinct on another

Leave a Comment