psql : Comment?

From: Bruce Tong <zztong(at)laxmi(dot)ev(dot)net>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: psql : Comment?
Date: 1999-08-13 17:35:53
Message-ID: Pine.LNX.4.10.9908131330300.23198-100000@laxmi.ev.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)laxmi(dot)ev(dot)net | -- Joe Walsh for the 21st Century

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Charles Tassell 1999-08-13 17:39:14 Re: [GENERAL] Environmental Variables
Previous Message Kyle Bateman 1999-08-13 16:25:03 Job opportunity