Re: psql -1 with multiple files?

From: Jay Levitt <jay(dot)levitt(at)gmail(dot)com>
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: psql -1 with multiple files?
Date: 2011-12-02 00:01:14
Message-ID: 4ED8154A.7030507@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Steve Crawford wrote:
> On 12/01/2011 02:01 PM, Jay Levitt wrote:
>> Is there a way to load multiple .sql files in a single transaction?
> Alternately, since -1 basically wraps your input in a BEGIN...your
> statements...COMMIT you could do that yourself with a begin.sql and commit.sql:
>
> cat begin.sql file1.sql file2.sql ... commit.sql | psql ...

Man, can I not see the forest for the trees sometimes. Thanks.

Jay

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marcin Mańk 2011-12-02 00:50:01 Re: Query Optimizer makes a poor choice
Previous Message Steve Crawford 2011-12-01 23:28:55 Re: psql -1 with multiple files?