From: | Hadley Willan <hadley(dot)willan(at)deeperdesign(dot)co(dot)nz> |
---|---|
To: | Postgresql General <pgsql-general(at)postgresql(dot)org> |
Subject: | Simple question about messages |
Date: | 2003-04-29 22:43:26 |
Message-ID: | 1051656206.1866.90.camel@atlas.sol.deeper.co.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi All,
I've written a script that trawls through my sql code and in
conjunction with GPP parses my code. I can then pipe this output from
bash to a file and as one large file, pipe that sql into postgresql from
the cli psql.
eg.
psql -h gaia -U postgres -d template1 < create_users_and_database.sql >
dbout.txt
That way the output is put into a file rather than just the terminal.
It also reduces the clutter on the screen and off the mark I get the
table create notice like NOTICE:: CREATE TABLE ......
However, may question is that how do I raise custom notices like 'At
point x' or something. That way I can get a feel for where the commands
are and that way when the occasiconal 'parser: parse error at or near
'WHERE' character 2' pops up know where roughly to find it.
I've tried RAISE NOTICE 'xxx'; but that fails.
SELECT 'point x' AS point; creates a larger output of result name and
text, but that isn't ideal.
I've flicked through the docs, but nothing jumps out at me?
Thanks.
--
Hadley Willan > Systems Development > Deeper Design Limited. +64(7)377-3328
hadley(dot)willan(at)deeperdesign(dot)co(dot)nz > www.deeperdesign.com > +64(21)-28-41-463
Level 1, 4 Tamamutu St, PO Box 90, TAUPO 2730, New Zealand.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-04-29 22:52:00 | Re: Simple question about messages |
Previous Message | Tom Lane | 2003-04-29 22:36:59 | Re: ERROR: ExecutePlan: (junk) `ctid' is NULL! |