Re: I need to take metadata from a shell script.

On 5/6/2010 2:57 AM, Jaume Calm 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.
>

Depending on what version of PG you are on, try:

psql -ltA

a little read, cut, awk, perl, etc action and you should be good.

-Andy