Skip site navigation (1) Skip section navigation (2)

Re: [ADMIN] import limited to 1000 tuples

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: David(dot)Bear(at)asu(dot)edu
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ADMIN] import limited to 1000 tuples
Date: 2004-11-11 01:26:10
Message-ID: 200411102026.10933.xzilla@users.sourceforge.net (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-odbc
On Wednesday 10 November 2004 01:21, David Bear wrote:
> I am migrating data from msaccess. Using msaccess own export function
> I was able to export to an odbc data source -- I chose the postgres
> odbc source. The export went fine except it only save 1000 tupples
> from the access data source. These are not real big tables, but they
> do have almost 2000 tupples in them. Is there a limit to the number of
> tupples that can be exported/created through the odbc driver?

I'm fairly certain there's no limit in the ODBC driver (though I am 
re-directing to -odbc in case anyone tries to chime in), though I think I've 
hit this problem in access before.  Is it possible for you to export to csv 
and then import the data in ? 

-- 
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

In response to

pgsql-odbc by date

Next:From: Dave PageDate: 2004-11-11 09:22:35
Subject: Re: 08.00.0002 useless :-)
Previous:From: Jaime CasanovaDate: 2004-11-10 21:00:49
Subject: Re: ODBC Driver stability

pgsql-admin by date

Next:From: Ben KimDate: 2004-11-11 05:21:28
Subject: request for feature - mixed case name handling
Previous:From: S. C.Date: 2004-11-11 01:07:09
Subject: Re: nscd [was] how do you run postgres without dns server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group