I have a classic 3-environments setting (dev, staging and production), each with its own RDS PostgreSQL 9.3. The client/server versions are
psql (9.3.5, server 9.3.3).
In order to keep the schemas aligned, I have a periodic schema diff job, which notifies me when the schemas differ.
A few days ago, I started getting many of these diffs:
CREATE TABLE ... ... < title pg_catalog.text, < subtitle pg_catalog.text, --- > title text, > subtitle text,
text fields in staging was somehow converted to
pg_catalog.text in prod.
What is the difference between
pg_catalog.text? How can I equate the two schemas?