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