In PostgreSQL, there is no
SHOW CREATE statement, known for example from MySQL. But when you use the pgAdmin III client program and go to object details, you see the corresponding CREATE statement.
So here is my question:
How does pgAdmin III build the CREATE statements it shows? Does it use psql's
\d command or some completely different PostreSQL API? If so, how can I use it?