On Wed, Aug 31, 2005 at 03:17:29PM -0400, Frank wrote: > Thanks for clearing up some confusion. > > >>Look in the contrib/mysql directory in the source file (or install the > contrib packages for your system, assuming they come with that contrib > package<< > > I do not have that, where can I download it? It's part of the PostgreSQL source code, which you can download from the website. > This fails to insert records Yes, the values (), (), () syntax isn't supported yet (I think it's slated for 8.2). In the meantime you'll need to convert either to multiple insert statements (which you'll want to wrap in a BEGIN; COMMIT;) or better yet a copy statement. But really what you want to do is use the migration tools that are out there... > >> insert into category values > >> (4, 'Hardware - Monitor', 2, '2004-10-12 10:50:01'), > >> (5, 'Hardware - Printer', 2, '2004-10-12 10:50:02'), > >> (6, 'Hardware - Terminal', 2, '2004-10-12 10:50:02'), > >> (7, 'Hardware - PC Laptop', 2, '2004-10-12 10:50:02'), > >> (9, 'Hardware - Misc.', 1, '2004-10-12 10:51:00'), > >> (10, 'Hardware - PC Desktop', 2, '2004-10-12 10:50:03'), > >> (11, 'Software - PC', 2, '2004-10-12 10:50:03'), > >> (13, 'Software - Network', 2, '2004-10-12 10:50:04'), > >> (14, 'Software - Midrange, AS/400', 2, '2004-10-12 10:50:04'), > >> (15, 'Software - Server', 2, '2004-10-12 10:50:04'), > >> (16, 'Hardware - Wyse Terminal', 2, '2004-10-12 10:50:05'); > > Regards, > > Frank > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
