pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
psql -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