Re: [GENERAL] How to disable duplicate columns

2007-04-09 Thread Stephan Szabo
On Sun, 8 Apr 2007, Andrus wrote: > I have tables with large number of columns some of which are duplicate. > I need to use > > SELECT t1.*, t2.* FROM t1 join t2 using (t) > > since I don't know all column names of t1 and t2 tables at design time. > > In this case PostgreSQL returns table with du

Re: [GENERAL] How to disable duplicate columns

2007-04-09 Thread Merlin Moncure
On 4/8/07, Andrus <[EMAIL PROTECTED]> wrote: I have tables with large number of columns some of which are duplicate. I need to use SELECT t1.*, t2.* FROM t1 join t2 using (t) since I don't know all column names of t1 and t2 tables at design time. In this case PostgreSQL returns table with dup

[GENERAL] How to disable duplicate columns

2007-04-09 Thread Andrus
I have tables with large number of columns some of which are duplicate. I need to use SELECT t1.*, t2.* FROM t1 join t2 using (t) since I don't know all column names of t1 and t2 tables at design time. In this case PostgreSQL returns table with duplicate columns. How to force Postgres to return