Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Titles in generated synonyms (PostgreSQL)
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Titles in generated synonyms (PostgreSQL)
 Login/Join
 
Virtuoso
posted
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 :
 
Posts: 1639 | Location: Enschede, Netherlands | Registered: August 12, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.


WebFOCUS 8204, Unix, Windows
 
Posts: 1606 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Titles in generated synonyms (PostgreSQL)

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.