PostgreSQL

Завершение соединения с базой данных

SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = '';

Запрос для связи с PostgreSQL в Navisworks

SELECT * FROM public.yourtable WHERE "NWUniqueID" = %prop("Entity Handle", "Value");

Last updated

Was this helpful?