Escaping keyword-like column names in Postgres

by

Simply enclose year in double quotes to stop it being interpreted as a keyword:

INSERT INTO table (id, name, "year") VALUES ( ... );

From the documentation:

There is a second kind of identifier: the delimited identifier or
quoted identifier. It is formed by enclosing an arbitrary sequence of
characters in double-quotes (“). A delimited identifier is always an
identifier, never a key word. So “select” could be used to refer to a
column or table named “select”, whereas an unquoted select would be
taken as a key word and would therefore provoke a parse error when
used where a table or column name is expected.

More Related Contents:

  1. Sort by column ASC, but NULL values first?
  2. Using an Alias column in the where clause in Postgresql
  3. How to return result of a SELECT inside a function in PostgreSQL?
  4. Grouped LIMIT in PostgreSQL: show the first N rows for each group?
  5. Update multiple rows in same query using PostgreSQL
  6. Humanized or natural number sorting of mixed word-and-number strings
  7. Pass multiple values in single parameter
  8. Custom SERIAL / autoincrement per group of values
  9. How do I determine the last day of the previous month using PostgreSQL?
  10. PL/pgSQL checking if a row exists
  11. postgres column “X” does not exist
  12. Multiple CTE in single query
  13. Return pre-UPDATE column values using SQL only
  14. PostgreSQL equivalent for TOP n WITH TIES: LIMIT “with ties”?
  15. Selecting data into a Postgres array
  16. SQL syntax term for ‘WHERE (col1, col2) < (val1, val2)'
  17. Get the distinct sum of a joined table column
  18. How much disk-space is needed to store a NULL value using postgresql DB?
  19. Aggregating (x,y) coordinate point clouds in PostgreSQL
  20. PostgreSQL convert columns to rows? Transpose?
  21. PostgreSQL delete with inner join
  22. Regular expression in PostgreSQL LIKE clause
  23. Postgres Error: More than one row returned by a subquery used as an expression
  24. Generate DEFAULT values in a CTE UPSERT using PostgreSQL 9.3
  25. How to detect query which holds the lock in Postgres?
  26. PostgreSQL how to create a copy of a database or schema?
  27. PostgreSQL: fill NULL values in timeserie query with previous value
  28. Postgres: convert single row to multiple rows (unpivot)
  29. Get most common value for each value of another column in SQL
  30. PostgreSQL: top n entries per item in same table

Leave a Comment