cancel
Showing results for 
Search instead for 
Did you mean: 

about FTS and SYS_CONTEXT in postgres EDB

SOLVED
Highlighted
Gold Adventurer

about FTS and SYS_CONTEXT in postgres EDB

Hi all,

 

I want to know  if postgres EDB can execute FTS over binary data (for example pdf, docx, etc)

 

and if postgres EDB can get the value of SYS_CONTEXT (CLIENT_IDENTIFIER)

 

 

regards

 

PD: if it is not possible, in the future you are thinking  implement it?

 
1 ACCEPTED SOLUTION

Accepted Solutions
EDB Team Member

Re: about FTS and SYS_CONTEXT in postgres EDB

Hi asotolongo,

 

Full-text search is an indexing system for text. It cannot index PDF, Microsoft Word documents, or other random binary files.

It does not have provision for text-extraction tool callbacks, etc.

 

A work-around for this is that you can create a table that contains text extracted from those files using external tools along with an oid that refers to the file itself, then full-text index that table of extracted text.  

 

For your second question by CLIENT_IDENTIFIER do you mean client's IP address or hostname then this is possible in EPAS.

 

Hope this helps.

2 REPLIES 2
EDB Team Member

Re: about FTS and SYS_CONTEXT in postgres EDB

Hi asotolongo,

 

Full-text search is an indexing system for text. It cannot index PDF, Microsoft Word documents, or other random binary files.

It does not have provision for text-extraction tool callbacks, etc.

 

A work-around for this is that you can create a table that contains text extracted from those files using external tools along with an oid that refers to the file itself, then full-text index that table of extracted text.  

 

For your second question by CLIENT_IDENTIFIER do you mean client's IP address or hostname then this is possible in EPAS.

 

Hope this helps.

Gold Adventurer

Re: about FTS and SYS_CONTEXT in postgres EDB

hi @chaitalirs 

That's what we did

 

thanks