Get Doctype Details from the Doctype using the Postgres SQL

Hi All,

I have created the site using the Postgresql.
I am trying to get the Doctype detail using the system console on frappe or terminal. please let me know steps need to perform on querying to get the doctype details

earlier I use “SELECT * FROM `tab” on MariaDB to get the info but same script it is not working.

Thanks

Please use double quotation marks "tab Item" to identify your table.