psql : Comment?
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
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@eskimo.com
Try to use --
-- Patient Records are really cool.
CREATE TABLE patient
(
id integer unqiue not null, -- A nifty column, eh?
);
-----Message d'origine-----
De : Bruce Tong <zztong@laxmi.ev.net>
� : PostgreSQL General <pgsql-general@postgreSQL.org>
Date : samedi 14 ao�t 1999 04:55
Objet : [GENERAL] psql : Comment?
Show quoted text
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
Import Notes
Resolved by subject fallback