Can you do a foreign key within a single table, though? I've only ever seen foreign key constraints tying a field in one table to a field in another table.

A new MySQL foreign data wrapper for Postgres is designed to help firms combine and query data from their databases.