What is the difference between a relational database and an object relational database?

Question

PostgreSQL

What is the difference in structure?
What would postressql tables look like if they were relational?
What is the difference and what is the benefit of object-relational databases?

Answer 1

In an object-relational DBMS, you can create objects, inherit and extend them, you can create complex data types.
Read the PostgreSQL documentation about inheritance, create type, and create domain.
https://www.postgresql.org/docs/current/static/tut...
https://www.postgresql.org/docs/current/static/sql...
https://www.postgresql.org/ docs/current/static/sql...

Answer 2

In fact, postressql has always been relational, and in the last 2-3 years a bunch of additional indexers have been screwed into blobs. And the opportunity has come to do an "objective" search on these blobs.
Actually, the profit is that individual fields can be indexed in the manner of text search engines, for example, by json fields with some aggregation.
In my opinion, this is just a kind of text search in a relational database, although much improved.
The benefit is to store json + relational information, in many cases this is beneficial. In others, just taking nosql (elastic / mongo) is more profitable. Well, many will probably refuse a separate solr / elastic.

Answer 3

Postgressql is a relational database. And what kind of object-relational db? Post a link to read