How to check foreign table permissions on Postgres

Question

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.

Have you tried `\dp` ? – Kamil Gosciminski Oct 07 '16 at 19:55 — Kamil Gosciminski, Oct 07 '16 at 19:55
Hey, that's exactly what I needed. Thanks! – Alexander Rumanovsk Oct 07 '16 at 20:26 — Alexander Rumanovsk, Oct 07 '16 at 20:26

score 1 · Accepted Answer · answered Oct 07 '16 at 20:34

1

\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.

answered Oct 07 '16 at 20:34

Kamil Gosciminski

16,547
8
49
72

How to check foreign table permissions on Postgres

1 Answers1