Postgres Pro
Downloads
Home   >   mailing lists

Re: Moving data from SQL Server to Postgres via VFP ODBC Driver - Mailing list pgsql-odbc

From Tom Lane
Subject Re: Moving data from SQL Server to Postgres via VFP ODBC Driver
Date
Msg-id 11995.1281380594@sss.pgh.pa.us
Whole thread Raw
In response to Moving data from SQL Server to Postgres via VFP ODBC Driver  (Calvin <calvinsmith266@hotmail.com>)
List pgsql-odbc
Tree view 
Calvin <calvinsmith266@hotmail.com> writes:
> Is there any way to keep varying character fields from being padded out to their
> maximum length.

I suspect that your "varying" fields are in fact declared as just
CHAR(n).  Use VARCHAR(n), or if there isn't a particularly good reason
to have a specific length limit, use TEXT.

            regards, tom lane

pgsql-odbc by date:

Previous
From: Richard Broersma
Date:
Subject: Re: Moving data from SQL Server to Postgres via VFP ODBC Driver
Next
From: Michal Seliga
Date:
Subject: i cannot use odbc with postgresql in linux