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

From: pinker <pinker(at)onet(dot)eu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Is there a "right" way to test if a database is empty?
Date: 2018-01-17 16:01:35
Message-ID: 1516204895514-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I always do:\l+and then you can compare the size:new_one | postgres | UTF8
| en_US.UTF-8 | en_US.UTF-8 | | *7869 kB* | pg_default
| template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
+| *7869 kB* | pg_default | | | |
| postgres=CTc/postgres | | | template1 | postgres |
UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +| *7869 kB* |
pg_default

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Graham Leggett 2018-01-17 16:04:01 Re: Is there a "right" way to test if a database is empty?
Previous Message Marina Polyakova 2018-01-17 15:50:05 Re: master make check fails on Solaris 10