| From: | "J(dot)T(dot) Hartzler" <dba(at)wap(dot)ntelos(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: |
| Date: | 2002-07-25 17:02:20 |
| Message-ID: | Pine.LNX.4.43.0207251301150.16126-100000@wap.ntelos.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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(at)wap(dot)ntelos(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sibusiso xolo | 2002-07-26 01:02:19 | howto connect OO to pgsql- with data-insertion access. |
| Previous Message | Jesús López | 2002-07-25 16:56:15 | Re: extract data and store |