Re: Q: extract database name from directory dump - Mailing list pgsql-general

On 3/12/2016 1:40 PM, John R Pierce wrote:
> pg_restore -l junky | awk  '/^;\wdbname: (.*)/{print $3}'

oops, pasted the wrong one, meant that one to be ...

     pg_restore -l junky | awk  '/^; +dbname: /{print $3}'


but I think the 2nd one is more robust

--
john r pierce, recycling bits in santa cruz