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.attnum>0 and a2.attrelid=t2.oid and t2.relkind='r' and a2.attnum>0
and t1.relname<t2.relname and a1.attname = a2.attname;
>
> Thanks
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
-Achilleus
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
