Re: Cannot INDEX an Access97 ODBC export?

From: "Bryan White" <bryan(at)arcamax(dot)com>
To: <lampe(at)durawebs(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cannot INDEX an Access97 ODBC export?
Date: 2000-06-09 15:39:33
Message-ID: 00c801bfd228$e884b800$2dd260d1@arcamax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> Error return is that it is not able to find the attribute
"any_column_name" in the table.

This maybe obvious but have you looked at the table layout to see if the
column exists. You may have a problem with spaces in the name or upper case
letters in the name. In either case you must quote the name (table or
column). Un quoted names are converted to all lower case.

In psql do: \d tablename
or from the shell do: pg_dump -s -t tablename

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Peterson 2000-06-09 15:50:52 Re: Re: PHP and inet data type
Previous Message Mihai Gheorghiu 2000-06-09 15:27:09 Data type