psql : Comment? - Mailing list pgsql-general

From Bruce Tong
Subject psql : Comment?
Date
Msg-id Pine.LNX.4.10.9908131330300.23198-100000@laxmi.ev.net
Whole thread Raw
Responses Re: [GENERAL] psql : Comment?  (Simon Drabble <simon@eskimo.com>)
List pgsql-general
I tend to put SQL into text files and then let a makefile run them through
psql. I'd like to be able to put comments into these SQL files. Is there a
character psql accepts as a comment?

Example (create.sql) ...


# Patient Records are really cool.

CREATE TABLE patient
(
    id     integer unqiue not null,     # A nifty column, eh?
);


Example (makefile) ...

create    :
    psql -f create.sql

--

Bruce Tong                 |  Got me an office; I'm there late at night.
Systems Programmer         |  Just send me e-mail, maybe I'll write.
Electronic Vision / FITNE  |
zztong@laxmi.ev.net        |  -- Joe Walsh for the 21st Century



pgsql-general by date:

Previous
From: Charles Tassell
Date:
Subject: Re: [GENERAL] Environmental Variables
Next
From: Simon Drabble
Date:
Subject: Re: [GENERAL] psql : Comment?