pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedimport 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>
2004-11-11 01:26 ` Re: [ADMIN] import limited to 1000 tuples Robert Treat <xzilla@users.sourceforge.net>
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-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>
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