How to query the create table statement in pgsql?

In PostgreSQL (pgsql), there are two ways to query the create table statement for a table.

1. Using pgAdmin, connect to the PostgreSQL database, expand the corresponding database and table schema, right-click on the table that needs the create table statement, select “Scripts” -> “CREATE script”. This will open an SQL query window containing the create table statement for that table.
2. To query information schema
   In PostgreSQL, each database has a schema called “information_schema” which contains views of system metadata. You can use the following query to retrieve the create table statement for a table:
3. Retrieve the statement for creating a table named ‘table_name’ using the schema ‘schema_name’ from the information schema.
4. Replace “table_name” with the name of the table to be queried, and replace “schema_name” with the schema name to which the table belongs. Running this query will return the create table statement for the specified table.

Please note that the second method is only applicable to database users with sufficient permissions.