Re: newbie - postgresql or mysql

[Frank <farocco@xxxxxxxxxxx>]

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 



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend