I would like to use the following syntaxis in my PL/pgSQL code:
INSERT INTO table (table.column1, table.column2) VALUES (1, 2);
But somehow it doesn't work. Does anybody know if such a notation it is prohibited or I do something wrong?
Firstly, if you really want to use the name
but assuming your table name is something different (which I highly recommended), the error returned indicates that the parser is interpreting
This interpretation is sensible, as
You probably just want the following as already suggested by DrColossos:
Be sure to check out the docs on how to create a schema. It says, that
This would also make no syntactical sense since you already know what table you are referring to. IF you need to query the schema, you would write it.