# Indexing PostgreSQL Database,schemas, tables and rows in Elasticsearch

**URL:** <https://discuss.elastic.co/t/indexing-postgresql-database-schemas-tables-and-rows-in-elasticsearch/157882>\
**Category:** Elasticsearch\
**Created:** [November 22, 2018, 1:05pm UTC](https://discuss.elastic.co/t/indexing-postgresql-database-schemas-tables-and-rows-in-elasticsearch/157882 "2018-11-22T13:05:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kaushalshriyan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kaushalshriyan/32/44563_2.png) [@kaushalshriyan](https://discuss.elastic.co/u/kaushalshriyan)\
**Post date:** [November 22, 2018, 1:05pm UTC](https://discuss.elastic.co/t/indexing-postgresql-database-schemas-tables-and-rows-in-elasticsearch/157882/1 "2018-11-22T13:05:45Z")

</div>

Hi,

I have a question regarding indexing PostgreSQL DB data. I am still finding it hard to understand the concepts of ES indexing, type, and document terminologies.

[https://www.elastic.co/guide/en/elasticsearch/reference/current/glossary.html#glossary-text](https://www.elastic.co/guide/en/elasticsearch/reference/current/glossary.html#glossary-text)

In Postgresql DB the data is normalized. We have Database,schemas, tables and rows. I am not sure about ES terminologies to be applied to PostgreSQL DB data structure.

My question is which PostgreSQL DB data structure (Database, schemas, columns or rows) to be indexed for searching data in ES Sink. I am confused to correlate with the PostgreSQL DB data.

Any sample examples if you can provide me to help me understand the application of Elasticsearch indexing and document IDs?

Thanks in Advance.

Best Regards,

Kaushal

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [December 20, 2018, 1:05pm UTC](https://discuss.elastic.co/t/indexing-postgresql-database-schemas-tables-and-rows-in-elasticsearch/157882/2 "2018-12-20T13:05:49Z")

</div>

Closed on December 20, 2018, 1:05pm UTC

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.