Re: [ADMIN] mysql to pgsql

One correction:

On Fri, Feb 18, 2000 at 11:23:49AM +0200, Nikolay Mijaylov wrote:
> Hya
>
> Remove all Mysql comments, unfortunately pg, cant support
> comments,
> they begins with # if i not mistake

pgsql supports SQL standard comments. A comment is introduced by the
token --, and ends at the next newline. I have many sql script files
that look like:

create table testit ( -- this is a test table
f1 int, -- this is a test integer
f2 real, -- this is a real, or float
f3 text -- this is a variable length text element
);

Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005