]> granicus.if.org Git - postgresql/commit
Improve RLS documentation with respect to COPY
authorJoe Conway <mail@joeconway.com>
Fri, 23 Dec 2016 01:56:50 +0000 (17:56 -0800)
committerJoe Conway <mail@joeconway.com>
Fri, 23 Dec 2016 01:56:50 +0000 (17:56 -0800)
commit0a85c102254b72ec7ce16bc504206a1a5c84bd76
treec21832db2fe01005d3a45fed1872cac642021f0e
parent2ac3ef7a01df859c62d0a02333b646d65eaec5ff
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