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: (view raw, whole thread or download thread mbox)
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.  


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.
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-2017 The PostgreSQL Global Development Group