| Lists: | pgsql-general |
|---|
| 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 |
| 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
| From: | Simon Drabble <simon(at)eskimo(dot)com> |
|---|---|
| To: | Bruce Tong <zztong(at)laxmi(dot)ev(dot)net> |
| Cc: | PostgreSQL General <pgsql-general(at)postgreSQL(dot)org> |
| Subject: | Re: [GENERAL] psql : Comment? |
| Date: | 1999-08-13 18:03:43 |
| Message-ID: | Pine.LNX.3.96.990813140104.10780A-100000@dragon |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On Fri, 13 Aug 1999, Bruce Tong wrote:
> 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?
>
>
> Bruce Tong | Got me an office; I'm there late at night.
Standard(?) SQL method is to use -- , e.g.
CREATE TABLE foo (
bar int, -- an integer
baz text -- some text
);
Simon.
--
"Don't anthropomorphise computers - they don't like it."
Simon Drabble It's like karma for your brain.
simon(at)eskimo(dot)com