Does PostgreSQL support INSERT syntax of this kind - insert into table (table.col1, table.col2, table.col3) values('one', 'two', 'three')? Trying it out generates an error. It works when the 'table' bit is removed from the column names. F Church
Does PostgreSQL support INSERT syntax of this kind - insert into table (table.col1, table.col2, table.col3) values('one', 'two', 'three')? Trying it out generates an error. It works when the 'table' bit is removed from the column names. F Church