On 7/10/22 12:47, Igor Korot wrote:
So there is no "query" per se?
Also how do I pass the table name?
Thank you.
You can create one from the catalog tables. Personally, I would use INFORMATION_SCHEMA to avoid pg_class and pg_attribute. However, there is an extension which does that for you. Somebody else has already done the hard work.
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com