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
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
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
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
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
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