Re: [GENERAL] Cannot INDEX an Access97 ODBC

[Tom Lane]

<[EMAIL PROTECTED]> 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