How to view created columns in created table in PostgreSQL?

Question

PostgreSQL

In Mysql, this is possible: but how to display this in posgres? This command only works in the console: How can I view it with a query in DBeaver?
show columns from имя_таблицы;
\d имя_таблицы;

Answer 1

Column information is contained in the information_schema.columns view

SELECT
  *
FROM
  information_schema.columns
WHERE
  table_schema = 'schema_name'
  AND table_name = 'table_name';

PostgreSQL information_schema.columns
for example:

create table books (
  ID INT,
  	AUTHOR VARCHAR
);


SELECT
  *
FROM
  information_schema.columns
WHERE	table_name = 'books';