Since version 9.1, PostgreSQL supports the creation of UNLOGGED tables which do not use the WAL and are truncated during any DB recovery. See documentation: create unlogged table

Where does PostgreSQL store the information, whether a relation is UNLOGGED? I am looking for a query to list all relations that are UNLOGGED.

Thanks in advance

postgresql postgresql-9.1
Edit
Report