search

matthewfranglen / postgres-elasticsearch-fdw

Postgres to Elastic Search Foreign Data Wrapper
MIT License
108 stars 32 forks source link

Could it support fields starting with an underscore, "_"? #18

Closed canob closed 3 years ago

canob commented 3 years ago

Hi,

Are fields starting with an underscore in ElasticSearch, like _index or _source, supported? Because they showed empty whe I do a select in the foreing table of PostgreSQL, and they have information in Elasticsearch. In the foreign table definition, I tried with index, _index, and "_index" without any luck.

Thanks in advance!

matthewfranglen commented 3 years ago

The fields in _source are what the table exposes. See the code.

To access the index you should use the rowid_column as described in the create foreign table section of the readme.

matthewfranglen commented 3 years ago

Hey is this still an issue?

canob commented 3 years ago

No, its ok. Thanks for your help.