That is what the problem was. I was not double quoting the colomn names.
Thanks for the info.
On Thu, 25 Jul 2002, Tom Lane wrote:
> "J.T. Hartzler" <dba@wap.ntelos.com> writes:
> > It looks to me like it is saying that the column specified by
> > COLUMN_NAME does not exsist but when I do a \dt TABLE_NAME it is
> > there.
>
> And spelled how, exactly? I'm betting on a case-sensitivity issue
> here. Unquoted identifiers in SQL commands fold to lower case.
>
> regards, tom lane
>