Postgres Pro
Downloads
Home   >   mailing lists

Re: I need to take metadata from a shell script. - Mailing list pgsql-general

From Thom Brown
Subject Re: I need to take metadata from a shell script.
Date
Msg-id o2jbddc86151005060811zb40326e7ta2fc49f991761cd6@mail.gmail.com
Whole thread Raw
In response to I need to take metadata from a shell script.  ("Jaume Calm" <jaume@isac.cat>)
List pgsql-general
Tree view
On 6 May 2010 08:57, Jaume Calm <jaume@isac.cat> wrote:

Hi! I was searching for a command like pg_dumpall but with the difference that I don’t want a single file for all databases, i would like to have a file for each one.

 

I couldn’t fins such command, so the only option I see is to write a shell script with a loop for all the DBs. The problem is that I’m unable to find the way to obtain the DBs’ names in a shell script. Can someone help me with this?

 

Best regards and thank you all for your time.


You could try:

psql -l | cut -d "|" -f 1 | tail -n +4 | head -n -2

A bit hacky, and there might be a better way.

Regards

Thom

pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: Fwd: help on postgres regexp
Next
From: Dave Vitek
Date:
Subject: pre-existing shared memory block is still in use after crashes