swh-schema: add PostgreSQL notification support for new objects

This allows a PostgreSQL client to listen to messages informing it of
new objects being added to the database.

Implements the SQL side of T526