column and table names

From: "stephen`" <mail(at)xesoftware(dot)com(dot)au>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: column and table names
Date: 2007-04-26 07:53:59
Message-ID: 000701c787d8$0d655960$6701a8c0@tablet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi

I am trying to find sql to get table and column names. I found these:



SELECT table_name FROM information_schema.tables WHERE table_schema =
'public'

This one works, but the column name one below doesn't.


SELECT column_name FROM information_schema.columns WHERE table_name
='marketLayout'

Can anyone tell me how to get the wording right?

Stephen Choularton
0413 545 182
02 9999 2226



Responses

Browse pgsql-novice by date

  From Date Subject
Next Message stephen` 2007-04-26 07:54:13 cannot insert or update
Previous Message stephen` 2007-04-26 07:53:43 pg_dump