Re: Comments in .sql files

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Claudio Lapidus" <clapidus(at)hotmail(dot)com>, "Chad N(dot) Tindel" <chad(at)tindel(dot)net>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Comments in .sql files
Date: 2003-08-01 07:46:18
Message-ID: 200308010846.18421.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nico Latzer 2003-08-01 07:47:50 Re: owner cant delete from table, permission denied
Previous Message Tambet Matiisen 2003-08-01 07:45:54 COPY and domains