Hi,

Based on the comment you have added, it seems you need to know which table hold, what sort of information's.

Lets take a case of sale order, if you need to know the which table in the PostgreSQL hold this records, you can open the sale order form view and in the url you can see an attribute model, this model represent the db table.

If you see in the url as sale.order, then its related postgreSQL table is sale_order .

Also if you open the debug mode(odoo developer mode), by clicking view meta data also you can get the model details.

Once you get the model details, using terminal or using tools like pgadmin, you can connect to database and perform the sql operations.

1. Odoo PG Admin

Thanks

The first and easiest is to enable debug mode, go to Settings->Technical->Models under database structure group->your_desired_model . It will show you exact same structure in postgres databases.

Or refer to Cybrosys Techno Solutions answer above.
Hope this will help you.

Hi,

You can get the list of tables in postgres database using two solutions either through pgadmin or through terminal

Check this link

https://phoenixnap.com/kb/how-to-connect-postgresql-database-command-line

https://linuxize.com/post/how-to-list-databases-tables-in-postgreqsl/

Regards