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

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Re: I need to take metadata from a shell script.
Дата
Msg-id o2jbddc86151005060811zb40326e7ta2fc49f991761cd6@mail.gmail.com
обсуждение исходный текст
Ответ на I need to take metadata from a shell script.  ("Jaume Calm" <jaume@isac.cat>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: Fwd: help on postgres regexp
Следующее
От: Dave Vitek
Дата:
Сообщение: pre-existing shared memory block is still in use after crashes