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,
The text
fields in staging was somehow converted to pg_catalog.text
in prod.
What is the difference between text
and pg_catalog.text
? How can I equate the two schemas?