Postgres Pro
Downloads
Home   >   mailing lists

using schema-qualified names in INSERTs - Mailing list pgsql-general

From Frank Church
Subject using schema-qualified names in INSERTs
Date
Msg-id 1139837611.43f08aab0eda1@webmail.adontendev.net
Whole thread Raw
Responses Re: using schema-qualified names in INSERTs  (Martijn van Oosterhout <kleptog@svana.org>)
Re: using schema-qualified names in INSERTs  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Sergey Karin
Date:
Subject: PG and Tivoli Data Protection
Next
From: Martijn van Oosterhout
Date:
Subject: Re: using schema-qualified names in INSERTs