Re: [ADMIN] mysql to pgsql - Mailing list pgsql-admin

From Ross J. Reedstrom
Subject Re: [ADMIN] mysql to pgsql
Date
Msg-id 20000218121305.B12742@rice.edu
Whole thread Raw
In response to Re: [ADMIN] mysql to pgsql  ("Nikolay Mijaylov" <nmmm@nmmm.nu>)
List pgsql-admin
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@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005

pgsql-admin by date:

Previous
From: "Daniele Medri"
Date:
Subject: Postgresql Limits with PHP query
Next
From: Dirk Heinrichs
Date:
Subject: Re: [ADMIN] mysql to pgsql