postgresqlquoted-identifier

How to insert data into `group` labeled table

I have a database in Postgres that has multiple tables. One of them is group. I know that this is a reserved name. The question is how to insert data into that table.

Solution

  • As documented in the manual you need to use double quotes:

    insert into "group" (column_1, column_2)
values (42, 'foo');