[SQL] List table with same column name

2003-10-23 Thread Abdul Wahab Dahalan
Hi! How do I list all the tables in the database which has a same column name?. Thanks ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] List table with same column name

2003-10-23 Thread achill
On Thu, 23 Oct 2003, Abdul Wahab Dahalan wrote: Hi! How do I list all the tables in the database which has a same column name?. SELECT t1.relname,a1.attname,t2.relname from pg_class t1,pg_attribute a1,pg_class t2,pg_attribute a2 where a1.attrelid=t1.oid and t1.relkind='r' and a1.attnum0 and

Re: [SQL] List table with same column name

2003-10-23 Thread Peter Childs
On Thu, 23 Oct 2003 [EMAIL PROTECTED] wrote: On Thu, 23 Oct 2003, Abdul Wahab Dahalan wrote: Hi! How do I list all the tables in the database which has a same column name?. SELECT t1.relname,a1.attname,t2.relname from pg_class t1,pg_attribute a1,pg_class t2,pg_attribute a2 where

Re: [SQL] List table with same column name

2003-10-23 Thread achill
On Thu, 23 Oct 2003, Peter Childs wrote: On Thu, 23 Oct 2003 [EMAIL PROTECTED] wrote: On Thu, 23 Oct 2003, Abdul Wahab Dahalan wrote: Hi! How do I list all the tables in the database which has a same column name?. SELECT t1.relname,a1.attname,t2.relname from pg_class

Re: [SQL] List table with same column name

2003-10-23 Thread Peter Childs
On Thu, 23 Oct 2003 [EMAIL PROTECTED] wrote: On Thu, 23 Oct 2003, Peter Childs wrote: On Thu, 23 Oct 2003 [EMAIL PROTECTED] wrote: On Thu, 23 Oct 2003, Abdul Wahab Dahalan wrote: Hi! How do I list all the tables in the database which has a same column name?. SELECT

Re: [SQL] List table with same column name

2003-10-23 Thread Achilleus Mantzios
On Thu, 23 Oct 2003, Peter Childs wrote: On Thu, 23 Oct 2003 [EMAIL PROTECTED] wrote: On Thu, 23 Oct 2003, Peter Childs wrote: On Thu, 23 Oct 2003 [EMAIL PROTECTED] wrote: On Thu, 23 Oct 2003, Abdul Wahab Dahalan wrote: Hi! How do I list all the tables in