renerdias/auditoria_fim.sql

Created April 23, 2019 21:36

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/renerdias/ed8c2a2875c69137046fbcbab229fba3.js"></script>
Save renerdias/ed8c2a2875c69137046fbcbab229fba3 to your computer and use it in GitHub Desktop.

Download ZIP

Cria tabela de auditoria para todas as tabelas em public

Raw

auditoria_fim.sql

	select
	tablename,
	auditoria.func_criar_tabela_auditoria(tablename, false)
	from
	pg_tables
	where
	schemaname = 'public'
	order by
	tablena

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment