On Sat, Mar 12, 2016 at 09:38:13PM +0100, Karsten Hilbert wrote:
> > Not-so-nice solutions coming to mind:
> >
> > - rely on the dump file name
> > - use pg_restore to create an SQL dump
> > with --create and grep the SQL file
> > for "create database ..."
> > - restore and compare psql -l output
> > before/after the fact
Another option that comes to mind is
pg_restore -l $DUMPDIR | grep dbname: | cut -f 7 -d ' ' -s
but that is quite fragile on the
-f 7 -d ' '
side of things but that's another question.
Start of pg_restore -l output:
;
; Archive created at 2016-03-07 21:15:06 CET
; dbname: gnumed_v20
; TOC Entries: 5187
; Compression: 0
; Dump Version: 1.12-0
; Format: DIRECTORY
; Integer: 4 bytes
; Offset: 8 bytes
; Dumped from database version: 9.5.1
; Dumped by pg_dump version: 9.5.1
;
;
; Selected TOC Entries:
;
8525; 1262 181294 DATABASE - gnumed_v20 gm-dbo
Any better suggestions ?
Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
