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@pervasive.com
Pervasive Software http://pervasive.com 512-569-9461