column and table names

["stephen`" <mail(at)xesoftware(dot)com(dot)au>]

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