Try exporting the tables (including table creation stmts) to a text file and
then ASCII ftping the file to the Unix Server to convert the CRLF and import
using pgsql...The documentation has the commands to import files...
----- Original Message -----
From: Stephen Birch <sbirch@ironmountainsystems.com>
To: <pgsql-general@postgreSQL.org>
Sent: Wednesday, November 24, 1999 11:47 PM
Subject: [GENERAL] Table names case sensitive?
> Although the PostgreSQL tables are created correctly, the write
> operations are failing. It looks like the ODBC driver is attempting to
> create tables with upper case names but PostgreSQL is converting the
> names to lower case. When the data pump tries to write data into
> PostgreSQL, the writes fail because the tables are not found since their
> names are in now lower case.
>
> It looks like PostgreSQL is not consistent with table case conversions.
> For the heck of it, I hacked postres.c to convert the the SQL strings to
> lower case on the fly - this kluge made the import work correctly.
>
> I have searched the lists and FAQs to see if the table name case
> disparity is a common problem, but drew a blank.
>
> The attempted data flow is as follows:
>
> Interbase 4.0 (SuSE 6.1 Linux) ---> Data Pump (NT) ---> PostgreSQL(SuSE
> 6.1 Linux)
>
