Re: Problems in creating table while migrating from Foxpro to Postgress using JDBC

From: Jeremy Buchmann <jeremy(at)wellsgaming(dot)com>
To: <arathis(at)cfindia-software(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Problems in creating table while migrating from Foxpro to Postgress using JDBC
Date: 2001-01-18 22:17:23
Message-ID: B68CAB72.551%jeremy@wellsgaming.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


> I am migrating the databases from Foxpro to Postgress using JDBC.
>
> I am extracting all the field values,type and width from the
> Foxpro database and putting that as a string .
>
> Ex: String stru
>
> Name varchar(20),id int4(4)

int4 doesn't need a size...it's always 4 bytes, AFAIK. So it should be:

Name varchar(20), id int4

--Jeremy

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Hal Lynch 2001-01-19 00:11:35 ODBC vs win2k and access
Previous Message Tom Lane 2001-01-18 21:03:57 Re: Deadlocks