Re: Comments in .sql files

On Friday 01 August 2003 04:54, Claudio Lapidus wrote:
> > 1.  It obviously doesn't like the # notation for comments.  What is the
>
> proper
>
> > way to put comments in schema files?
>
> Start the comment with two hyphens, like this:
>
> -- This is a comment. It will continue up to the newline.

Note that you can also do multi-line comments

/*
 like this
*/

That's not SQL standard AFAIK, but can be useful for commenting out sections
of a data dump.
--
  Richard Huxton
  Archonet Ltd