Thread: psql -f option

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

"Graham Vickrage" wrote: >I am trying to use the psql -f <filename> option to load a script into the >DB ( v7.0 ) from
thelinux 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
associatedline number in >the script. This would be a very useful feature for me as my scripts can be >very long. > >Is
therea 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
usalive with Christ even when we were     dead in transgressions-it is by grace you have been     saved."
Ephesians2:4,5 
 

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/