Re: using schema-qualified names in INSERTs

On Mon, Feb 13, 2006 at 01:33:31PM +0000, Frank Church wrote:
> 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.

No, and frankly, I can't see why it should. I mean, it's obvious that
you're inserting into "table", so why does it need to be mentioned
again for each and every column?

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.