COMMENT on "osc_zones" ...... ERROR at the opening quotation - Mailing list pgsql-novice

From joe speigle
Subject COMMENT on "osc_zones" ...... ERROR at the opening quotation
Date
Msg-id 29489.16027.qm@web60719.mail.yahoo.com
Whole thread Raw
List pgsql-novice
hello guys,
this is one admin from the mysql2psql.perl gborg site
http://gborg.postgresql.org/project/mysql2psql/projdisplay.php
is its homepage
we are adding support for mysql comments and can generate the following
comment commands:
COMMENT ON "osc_zones"."zone_country_id" IS 'zone country id here
comment';
COMMENT ON "osc_zones" IS 'must be country zones';
the quotes are there in case people do not want their table names to all
be lowercased.  When the conversion script (mysql -> pg) you can specify a
flag --lowercase which will lowercase them.  If that's not set, they are
put in quotes.  If quotes are used, the above generate errors.
Isn't that valid, or doesn't the COMMENT command allow quotes?
I searched the internet but couldn't find an answer there, I only found
examples which did not include quotes.

thank you,

joesp




____________________________________________________________________________________
Never Miss an Email
Stay connected with Yahoo! Mail on your mobile.  Get started!
http://mobile.yahoo.com/services?promote=mail

pgsql-novice by date:

Previous
From: Ray Stell
Date:
Subject: Re: I'm very confused.
Next
From: Ron Arts
Date:
Subject: only best matches with ilike or regex matching