Jeff Frost <jeff@xxxxxxxxxxxxxxxxxxxxxx> writes: >> I guess I could pg_dumpall -s | grep "ALTER DATABASE" to grab that stuff. > That seems silly. Is this the best way to find this data: > SELECT name, setting FROM pg_settings where source = 'database' ORDER BY > name; No, you'd miss anything overridden locally in your session. I'd think about getting it out of pg_database.datconfig, instead. Or really the easiest way is to tweak the logic in pg_dumpall about what to dump when ... regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
