Re: Cannot INDEX an Access97 ODBC

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: lampe@durawebs.com
Cc: pgsql-general@postgresql.org
Date: 2000-06-09T17:49:53Z
Lists: pgsql-general
<lampe@durawebs.com> writes:
>  The psql CREATE INDEX statement can't see the imported column
> (name/attribute)... wierd?

I still think that Bryan's got the right idea --- Access probably
created the column name with some embedded blanks and/or upper-case
characters, which'd mean that you have to quote the column name in
order to refer to it.

It would be useful to see the output of
	 pg_dump -s -t tablename databasename
for this table.

			regards, tom lane