red_led red-led
red-led
/ copyTableIndexes.sql
Last active
August 29, 2015 14:18
Postgres function for table indexes and privileges copying
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE OR REPLACE FUNCTION | |
| copyTableIndexes(fromSchema varchar, fromTable varchar, toSchema varchar, toTable varchar) | |
| RETURNS void AS $$ | |
| DECLARE | |
| oneIndex record; | |
| q text; | |
| BEGIN | |
| IF | |
| NOT EXISTS( | |
| SELECT * |