How to check whether table is busy or free before running the ALTER or creating TRIGGER on that table

[Raghavendra Rao J S V <raghavendrajsv@xxxxxxxxx>]

Hi All,

We have thousands of tables. Out of these tables we have few tables. Which are busy some times. If I execute any ALTER statement or creating trigger on those tables I am unable to do it. How to check whether table is busy or free before running the ALTER/DDL or creating TRIGGER on that table in postgresql database.

--

Regards,
Raghavendra Rao J S V