pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpsql -f option
3+ messages / 3 participants
[nested] [flat]
* psql -f option
@ 2001-01-04 16:04 Graham Vickrage <graham@digitalplanit.com>
2001-01-04 22:40 ` Re: psql -f option Oliver Elphick <olly@lfix.co.uk>
2001-01-04 23:14 ` Re: psql -f option Peter Eisentraut <peter_e@gmx.net>
0 siblings, 2 replies; 3+ messages in thread
From: Graham Vickrage @ 2001-01-04 16:04 UTC (permalink / raw)
To: pgsql-sql
I am trying to use the psql -f <filename> option to load a script into the
DB ( v7.0 ) from the linux command line.
The documentation says -f enables some nice features such as error messages
with line numbers. It seems to me that this is half true i.e. it shows me
error messages, its doesn't however give me the associated line number in
the script. This would be a very useful feature for me as my scripts can be
very long.
Is there a configuration option i am missing?
Thanx in advance
Graham
Attachments:
winmail.dat (application/ms-tnef, 1.7K) download
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: psql -f option
2001-01-04 16:04 psql -f option Graham Vickrage <graham@digitalplanit.com>
@ 2001-01-04 22:40 ` Oliver Elphick <olly@lfix.co.uk>
1 sibling, 0 replies; 3+ messages in thread
From: Oliver Elphick @ 2001-01-04 22:40 UTC (permalink / raw)
To: Graham Vickrage <graham@digitalplanit.com>; +Cc: pgsql-sql
"Graham Vickrage" wrote:
>I am trying to use the psql -f <filename> option to load a script into the
>DB ( v7.0 ) from the linux command line.
>
>The documentation says -f enables some nice features such as error messages
>with line numbers. It seems to me that this is half true i.e. it shows me
>error messages, its doesn't however give me the associated line number in
>the script. This would be a very useful feature for me as my scripts can be
>very long.
>
>Is there a configuration option i am missing?
Use -e as well, to have the SQL queries echoed; then you can see where
the errors are arising.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"But because of his great love for us, God, who is rich
in mercy, made us alive with Christ even when we were
dead in transgressions-it is by grace you have been
saved." Ephesians 2:4,5
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: psql -f option
2001-01-04 16:04 psql -f option Graham Vickrage <graham@digitalplanit.com>
@ 2001-01-04 23:14 ` Peter Eisentraut <peter_e@gmx.net>
1 sibling, 0 replies; 3+ messages in thread
From: Peter Eisentraut @ 2001-01-04 23:14 UTC (permalink / raw)
To: Graham Vickrage <graham@digitalplanit.com>; +Cc: pgsql-sql
Graham Vickrage writes:
> The documentation says -f enables some nice features such as error messages
> with line numbers. It seems to me that this is half true i.e. it shows me
> error messages, its doesn't however give me the associated line number in
> the script.
Works here:
$ psql -f /etc/sysctl.conf
psql:/etc/sysctl.conf:8: ERROR: parser: parse error at or near "#"
It looks to me like you are using an older psql, perhaps from a previous
installation.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-01-04 23:14 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-04 16:04 psql -f option Graham Vickrage <graham@digitalplanit.com>
2001-01-04 22:40 ` Oliver Elphick <olly@lfix.co.uk>
2001-01-04 23:14 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox