Sounds like I will have to get comfortable with the command line version of things... sigh... hate that.
Would that command be from within the psql SQL Shell that came as part of the install? (I'm living in Windows land).On Tue, Nov 26, 2013 at 1:24 PM, John R Pierce <pierce@xxxxxxxxxxxx> wrote:
On 11/26/2013 9:24 AM, Joey Quinn wrote:that means your GUI lobbed the entire file at postgres in a single PQexec call, so its all being executed as a single statement.
When I ran that command (select * from pg_stat_activity"), it returned the first six lines of the scripts. I'm fairly sure it has gotten a bit beyond that (been running over 24 hours now, and the size has increased about 300 GB). Am I missing something for it to tell me what the last line processed was?
psql -f "filename.sql" dbname would have processed the queries one at a time.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
