DEFINITIONS

Definitions More Info.
Definition ID836
TitlePOSTGRESQL
CategoryNOTES
DefinitionPostgresql create script for existing indexes
Definition DescriptionSELECT
REPLACE( pg_get_indexdef( format( '%I.%I', schemaname, indexname )::regclass ), ' INDEX ', ' INDEX IF NOT EXISTS ' )|| ';' AS ddl
FROM
pg_indexes
WHERE
schemaname = 'ERP'
RecordBycunay
Record Date01-06-2018 09:35:17
Düzenle
Kopyala
Sil