column and table names - Mailing list 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