Skip site navigation (1) Skip section navigation (2)

Re: column and table names

From: John DeSoi <desoi(at)pgedit(dot)com>
To: stephen` <mail(at)xesoftware(dot)com(dot)au>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: column and table names
Date: 2007-04-26 13:07:55
Message-ID: 6BB62513-A48F-4308-B674-262225A7CDC1@pgedit.com (view raw or flat)
Thread:
Lists: pgsql-novice
The column query should work assuming the table name is correct. Your  
table name may be case folded, so try with a lowercase 'L', e.g.  
'marketlayout'

John




On Apr 26, 2007, at 3:53 AM, stephen` wrote:

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



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


In response to

pgsql-novice by date

Next:From: Francois DeliegeDate: 2007-04-26 13:24:43
Subject: Re: moving data from windows to linux
Previous:From: Michael SwierczekDate: 2007-04-26 12:15:29
Subject: Re: custom crosstab question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group