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
– Kamil Gosciminski

2016-10-07 19:55:15 +00:00
Commented Oct 7, 2016 at 19:55 — Kamil Gosciminski
– Kamil Gosciminski, Commented Oct 7, 2016 at 19:55
Hey, that's exactly what I needed. Thanks!

Alexander Rumanovsk
– Alexander Rumanovsk

2016-10-07 20:26:29 +00:00
Commented Oct 7, 2016 at 20:26 — Alexander Rumanovsk
– Alexander Rumanovsk, Commented Oct 7, 2016 at 20:26

Kamil Gosciminski · Accepted Answer · 2016-10-07 20:34:26Z

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 7, 2016 at 20:34

Kamil Gosciminski

17.4k9 gold badges53 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to check foreign table permissions on Postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related