Re: Moving data from SQL Server to Postgres via VFP ODBC Driver

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Calvin <calvinsmith266(at)hotmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Moving data from SQL Server to Postgres via VFP ODBC Driver
Date: 2010-08-09 19:03:14
Message-ID: 11995.1281380594@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Calvin <calvinsmith266(at)hotmail(dot)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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Michal Seliga 2010-08-10 07:25:54 i cannot use odbc with postgresql in linux
Previous Message Richard Broersma 2010-08-09 18:50:59 Re: Moving data from SQL Server to Postgres via VFP ODBC Driver