1 Answer
1

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.

INSERT INTO address
("storeid",
"classtypeid",
...

Additionally, if you set the default values for the columns to NULL, you can omit them from the column list and use only those you really need

Thanks. I have changed that. I now get the error: Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at end of input LINE 48: $9 ^'
–
thomasFeb 12 '13 at 23:44

@thomas This would be the last line. Add a closing paranthesis ) to your statement.
–
Olaf DietscheFeb 12 '13 at 23:46

Aha. Great. I now (of course) get the following error: ` sequence address_id_seq1'. Which is odd. because I don't have a column named address_id_seq. Is it maybe a problem with the last autoincrement id` column?
–
thomasFeb 12 '13 at 23:52

@thomas I don't know. This depends on how you defined sequence address_id_seq1 and address, of course.
–
Olaf DietscheFeb 12 '13 at 23:56

I just never created anything called address_id_seq1 is the thing. I used phpPgAdmin to set up the database and that particular table. Can I define the sequence afterward?
–
thomasFeb 12 '13 at 23:58