> Jochem van Dieten wrote:
>
>> You have defined case-sensitive table names:
>> http://www.postgresql.org/docs/current/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
>>
>> You should be able to query them as using:
>> <cfquery ...>
>> SELECT *
>> FROM "SwaterType"
>> </cfquery>
>>
>> But I would recommend dumping your schema, removing the double
>> quotes and restoring.
>
> Thanks! I would never have thought of this. I looked in the Oreilly manual for PostgreSQL and didn't find any obvious information about schemas.
Paper tends to be outdated pretty fast.
> So, you mean, deleting the database and creating a new one? And make the tables all lowercase?
Just dropping and recreating the tables would suffice. And you
don't have to make them lowercase, use whatever case you want but
don't use double quotes around identifiers.
If you are adventurous, you could also try the following query
that should fix this for you, but if you have defined views and
triggers there might be side-effects:
UPDATE pg_catalog.pg_class
SET relname = Lower(relname)
WHERE relkind = 'r'
Jochem
--
When you don't want to be surprised by the revolution
organize one yourself
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
