pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
import limited to 1000 tuples
2+ messages / 2 participants
[nested] [flat]

* import limited to 1000 tuples
@ 2004-11-10 06:21  David Bear <David.Bear@asu.edu>
  0 siblings, 1 reply; 2+ messages in thread

From: David Bear @ 2004-11-10 06:21 UTC (permalink / raw)
  To: pgsql-admin

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?

-- 
David Bear
phone: 	480-965-8257
fax: 	480-965-9189
College of Public Programs/ASU
Wilson Hall 232
Tempe, AZ 85287-0803
 "Beware the IP portfolio, everyone will be suspect of trespassing"



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [ADMIN] import limited to 1000 tuples
@ 2004-11-11 01:26  Robert Treat <xzilla@users.sourceforge.net>
  parent: David Bear <David.Bear@asu.edu>
  0 siblings, 0 replies; 2+ messages in thread

From: Robert Treat @ 2004-11-11 01:26 UTC (permalink / raw)
  To: David.Bear@asu.edu; +Cc: pgsql-odbc@postgresql.org

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-11-11 01:26 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-11-10 06:21 import limited to 1000 tuples David Bear <David.Bear@asu.edu>
2004-11-11 01:26 ` Robert Treat <xzilla@users.sourceforge.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox