Definitions More Info.
Definition ID	960
Title	POSTGRESQL
Category	NOTES
Definition	Postgresqldeki mevcut constraintleri Create scripti
Definition Description	https://confluence.atlassian.com/kb/how-to-drop-and-recreate-the-database-constraints-on-postgresql-776812450.html SELECT 'ALTER TABLE '||nspname||'."'||relname||'" ADD CONSTRAINT "'||conname||'" '|| pg_get_constraintdef(pg_constraint.oid)||';' FROM pg_constraint INNER JOIN pg_class ON conrelid=pg_class.oid INNER JOIN pg_namespace ON pg_namespace.oid=pg_class.relnamespace ORDER BY CASE WHEN contype='f' THEN 0 ELSE 1 END DESC,contype DESC,nspname DESC,relname DESC,conname DESC
RecordBy	cunay
Record Date	26-07-2019 16:09:16
Düzenle
Kopyala
Sil