POSTGRESQL allows you to place any text into psql for use
as a comment. Two comment styles are possible. The presence of two dashes (-)
marks all text to the end of the line as a comment. POSTGRESQL also
understands C-style comments, where the comment begins with slash-asterisk (/*)
and ends with asterisk-slash (*/). Figure shows
both comment styles. Notice how the multiline comment
is marked by a psql command prompt of *>. It is a reminder
that you are in a multiline comment, just as -> is a reminder that
you are in a multiline statement, and '> is a reminder that you are
in a multiline quoted string.
test=> -- a single line comment
test=> /* a multiline
test*> comment */