psql : Comment?

Поиск
Список
Период
Сортировка
От Bruce Tong
Тема psql : Comment?
Дата
Msg-id Pine.LNX.4.10.9908131330300.23198-100000@laxmi.ev.net
обсуждение исходный текст
Ответы Re: [GENERAL] psql : Comment?  (Simon Drabble <simon@eskimo.com>)
Список 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 по дате отправления:

Предыдущее
От: Charles Tassell
Дата:
Сообщение: Re: [GENERAL] Environmental Variables
Следующее
От: Simon Drabble
Дата:
Сообщение: Re: [GENERAL] psql : Comment?