Re: psql scripts

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: iharding(at)destinydata(dot)com
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: psql scripts
Date: 2005-11-09 16:07:56
Message-ID: 16070.1131552476@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ian Harding <harding(dot)ian(at)gmail(dot)com> writes:
> That being the case, what could be causing my script to slow to a
> crawl when redirected to psql, but run fine from inside psql with -i?

Readline issue maybe? Please try this way
psql -f script.sql
as well as the stdin way; then try both with -n (no readline) added.

Also, what platform is this on, and PG 8.0.whatexactly?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message codeWarrior 2005-11-09 16:08:42 Re: insert on duplicate update?
Previous Message Tom Lane 2005-11-09 15:53:40 Re: Postmaster failing to start on reboot