Re: Comments in .sql files

"Chad N. Tindel" <chad(at)tindel(dot)net> writes:
> 1. It obviously doesn't like the # notation for comments. What is the proper
> way to put comments in schema files?

The SQL-standard comment syntaxes are

-- comment to end of line

/* C-like comment, possibly multiple lines */

We do both. There are a lot of not-SQL-standard comment syntaxes
accepted by various other databases ...

> 2. Why does postgres ignore the first insert? Shouldn't it just barf on
> the "#" line and keep going?

Since it doesn't think # is a comment introducer, it sees an invalid
multiline statement running up to the first ';'.

> 3. Is there a way to turn of the notices about creating implicit sequences
> and indices?

Set client_min_messages higher than NOTICE.

regards, tom lane