PG views defined as files in the DCT can readily be used in browse procedures. One simply gives the view a filename in the DCT just like a PG table (myschema.myviewname).
However, I’ve hit a snag if the DCT file happens to be a table returned from a PG function with a single parameter. The problem is that whatever filename and access level I have defined, I get a File Not Opened error from the FileManager.OpenFile method. I have confirmed that mypschema.myfuncname(date) is acceptable to PG, so I assumed this would be good to go in the DCT.
If anyone has successfully defined & used a PG returned table in the DCT, I would be thrilled to hear from you.