>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.
>
>Jochem
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. So, you mean, deleting the database and creating a new one? And make the tables all lowercase?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
