Is there a "right" way to test if a database is empty?

Поиск
Список
Период
Сортировка
От Graham Leggett
Тема Is there a "right" way to test if a database is empty?
Дата
Msg-id 71737871-79F4-4AA6-A393-05D05A9DFDF1@sharp.fm
обсуждение исходный текст
Ответы Re: Is there a "right" way to test if a database is empty?  (pinker <pinker@onet.eu>)
Re: Is there a "right" way to test if a database is empty?  (Graham Leggett <minfrin@sharp.fm>)
Re: Is there a "right" way to test if a database is empty?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Re: Is there a "right" way to test if a database is empty?  (hubert depesz lubaczewski <depesz@depesz.com>)
Список pgsql-hackers
Дерево обсуждения 
Hi all,

I need to test whether a database is empty, in other words “createdb” has been executed but no data of any kind appears
inthat database. 

What is the correct postgresql way to do this?

Is there a pg_isempty command or equivalent somewhere?

Regards,
Graham
—
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Marina Polyakova
Дата:
Сообщение: Re: master make check fails on Solaris 10
Следующее
От: Tom Lane
Дата:
Сообщение: Re: master make check fails on Solaris 10