Thanks for the feedback, sorry I was not more specific.
We are a non-profit hospital and have been using MySQL for about 4 years.
I wanted to convert some apps over to use postgresql and cannot find
a good tool to import and auto create the tables.
MySQL syntax is not compatible with postgresql.
I get:
ERROR: syntax error at or near "`" at character 14
from the MySQL output below.
CREATE TABLE `category` (
`category_id` int(11) NOT NULL auto_increment,
`category` char(50) default NULL,
`LastUser` int(11) NOT NULL default '0',
`LastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP on
update CURRENT_TIMESTAMP,
PRIMARY KEY (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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
