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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend