Re: multiple -f support

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: David Christensen <david(at)endpoint(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, Mark Wong <markwkm(at)gmail(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, gabrielle <gorthx(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: multiple -f support
Date: 2011-03-11 16:45:50
Message-ID: AANLkTi=kER88UBU6e2cZJvs1iH9zxAskBp1YvuJCyQ+N@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Mar 11, 2011 at 11:30 AM, David Christensen <david(at)endpoint(dot)com> wrote:
>
> On Mar 11, 2011, at 6:17 AM, Bruce Momjian wrote:
>
>> Robert Haas wrote:
>>> On Sun, Feb 6, 2011 at 11:16 AM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
>>>> I assume having psql support multiple -f files is not a high priority or
>>>> something we don't want.
>>>
>>> IIRC, nobody objected to the basic concept, and it seems useful.  I
>>> thought we were pretty close to committing something along those lines
>>> at one point, actually.  I don't remember exactly where the wheels
>>> came off.
>>>
>>> Maybe a TODO?
>>
>> Added to the psql section:
>>
>>       |Allow processing of multiple -f (file) options
>
>
> The original patch was a fairly trivial WIP one, which I started working on to add support for multiple -c flags interspersed as well.  I haven't looked at it in quite some time, though; there had been some concerns about how it worked in single-transaction mode and some other issues I don't recall off the top of my head.
>
> On this topic, I was thinking that it may be useful to provide an alternate multi-file syntax, a la git, with any argument following '--' in the argument list being interpreted as a file to process; i.e.,:
>
> $ psql -U user [option] database -- file1.sql file2.sql file3.sql
>
> This would allow things like shell expansion to work as expected:
>
> $ ls
> 01-schema.sql    02-data1.sql    03-fixups.sql
>
> $ psql database -- *.sql
>
> etc.

+1.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2011-03-11 16:46:27 Non-simultaneous file system snapshots as backups
Previous Message Heikki Linnakangas 2011-03-11 16:44:33 Re: B-tree parent pointer and checkpoints