Export the CREATE TABLE command in pure SQL

hey guys,

The most effective and simplest way to export the creation command of a
table is to use `pg_dump --schema-only`

However for one my projects, I don't have access to pg_dump and I need
to extract the data with a SQL or pl/pgsql function. I already wrote a
naïve implementation that handles primary keys and temporary tables. But
I realize it's probably incomplete and I will have to maintain it for
every new PostgreSQL major version....

How do you guys deal with this ? It seems that a lot of GUI tools are
able to "export the table structure".... Is there an extension somewhere
to do that ? Is it possible to write i in pure SQL ? If yes, there
anybody here interested in joining forces to build a shared export
function ?

Have nice day !

--
Damien Clochard