Today I Learned

hashrocket A Hashrocket project

Helpful psql commands for foreign data

PSQL has some helpful commands built in for viewing foreign data servers and tables if you are using them:

\des - list foreign servers

\deu - list user mappings

\det - list foreign tables

\dtE - list both local and foreign tables

\d <name of foreign table> - show columns, data types, and other table metadata

See More #sql TILs
Looking for help? Hashrocket developers believe that data quality is as important as code quality. We enjoy all the challenges of relational databases, from finding the fastest index, to structuring data to fit the needs of an application. We're eager to share our experiences; check out PG Casts, our series of free PostgreSQL screencasts.