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