Improve RLS documentation with respect to COPY
authorJoe Conway
Fri, 23 Dec 2016 01:57:14 +0000 (17:57 -0800)
committerJoe Conway
Fri, 23 Dec 2016 01:57:14 +0000 (17:57 -0800)
commit53afdef662ef77a3f27fc36dbc0472f855069fd3
treedab7402bd6cedbcf5e27e53295ef02c956f9d7c6
parente8236921773dab92f884db2685aee49fdc747cfc
Improve RLS documentation with respect to COPY

Documentation for pg_restore said COPY TO does not support row security
when in fact it should say COPY FROM. Fix that.

While at it, make it clear that "COPY FROM" does not allow RLS to be
enabled and INSERT should be used instead. Also that SELECT policies
will apply to COPY TO statements.

Back-patch to 9.5 where RLS first appeared.

Author: Joe Conway
Reviewed-By: Dean Rasheed and Robert Haas
Discussion: https://postgr.es/m/5744FA24.3030008%40joeconway.com
doc/src/sgml/ref/copy.sgml
doc/src/sgml/ref/pg_dump.sgml
doc/src/sgml/ref/pg_restore.sgml