DEFINITIONS
Definitions More Info.
Definition ID
836
Title
POSTGRESQL
Category
NOTES
Definition
Postgresql create script for existing indexes
Definition Description
SELECT
REPLACE( pg_get_indexdef( format( '%I.%I', schemaname, indexname )::regclass ), ' INDEX ', ' INDEX IF NOT EXISTS ' )|| ';' AS ddl
FROM
pg_indexes
WHERE
schemaname = 'ERP'
RecordBy
cunay
Record Date
01-06-2018 09:35:17
Düzenle
Kopyala
Sil