Re: Cannot INDEX an Access97 ODBC export? - Mailing list pgsql-general

From Bryan White
Subject Re: Cannot INDEX an Access97 ODBC export?
Date
Msg-id 00c801bfd228$e884b800$2dd260d1@arcamax.com
Whole thread Raw
In response to Cannot INDEX an Access97 ODBC export?  (<lampe@durawebs.com>)
List 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



pgsql-general by date:

Previous
From: Mihai Gheorghiu
Date:
Subject: Data type
Next
From: Ron Peterson
Date:
Subject: Re: Re: PHP and inet data type