Comments

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 */