Postgres Pro
Downloads
Home   >   mailing lists

Re: Is there a "right" way to test if a database is empty? - Mailing list pgsql-hackers

From pinker
Subject Re: Is there a "right" way to test if a database is empty?
Date
Msg-id 1516204895514-0.post@n3.nabble.com
Whole thread Raw
In response to Is there a "right" way to test if a database is empty?  (Graham Leggett <minfrin@sharp.fm>)
Responses Re: Is there a "right" way to test if a database is empty?
List pgsql-hackers
Tree view
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 the PostgreSQL - hackers mailing list archive at Nabble.com.

pgsql-hackers by date:

Previous
From: Marina Polyakova
Date:
Subject: Re: master make check fails on Solaris 10
Next
From: Graham Leggett
Date:
Subject: Re: Is there a "right" way to test if a database is empty?