[CLOSED] Titles in generated synonyms (PostgreSQL)
Does anyone know how to get these for PG?
Creation of synonyms currently does pick up the column comments for field descriptions, but titles are missing.
I found a techdoc describing a solution for MS SQL (https://techsupport.informationbuilders.com/techsps/ht/93512015.html), but that seems rather specific to that particular RDBMS.This message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux :
February 22, 2019, 10:08 AM
BabakNYC
If PG is like Oracle where you add Remarks using the COMMENT ON COLUMN syntax then you only have one extended attribute. That extended attribute will end up in the DESCRIPTION= in your synonym. SQL Server allows you to add both Titles and Descriptions with the sp_addextendedattributes and WebFOCUS will populate both TITLE= and DESCRIPTION=. When I had to add business titles to columns in an Oracle environment, I ended up using COMMENT syntax, create the synonym and replace DESCRIPTION= with TITLE= in the synonym. It's pretty nifty little trick that'll allow you to enrich the synonym with titles for all the fields.