Search code examples
postgresqlpostgres-fdw

How to check foreign table permissions on Postgres


does anybody know how to check user permissions for a foreign table on Postgres?

I've tried \dE and \det, but no luck.

I just want to know who can select, insert, update and delete from a foreign table.


Solution

  • \dp is a psql meta-command which lists tables with their associated access privileges. I believe \z is doing the same thing. It also lists privileges for accessing views and sequences.