using schema-qualified names in INSERTs

From: Frank Church <pgsql(at)adontendev(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: using schema-qualified names in INSERTs
Date: 2006-02-13 13:33:31
Message-ID: 1139837611.43f08aab0eda1@webmail.adontendev.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-02-13 13:39:15 Re: using schema-qualified names in INSERTs
Previous Message Sergey Karin 2006-02-13 13:13:20 PG and Tivoli Data Protection