Mysql – n equivalent of MySQL’s SHOW CREATE TABLE in Postgres

MySQLpostgresqlsql

Is there an equivalent of MySQL's SHOW CREATE TABLE in Postgres? Is this possible? If not what is the next best solution?

I need the statement because I use it to create the table on an remote server (over WCF).

Best Answer

You can try to trace in the PostgreSQL log file what pg_dump --table table --schema-only really does. Then you can use the same method to write your own sql function.

Related Solutions

Mysql – Postgres equivalent to MySQL’s \G

I'm not familiar enough with MySQL to know what the \G option does, but based on the documentation it looks like the psql \x option might do what you want.

It's a toggle, though, so you do it before you submit the query.

\x
select * from sometable;

Postgresql – n easy way to partially backup Postgres

You can try the COPY command, but note that this sucks for incremental backups.

Another (possibly better depending) option may be a hot standby server that you shut down and take (filesystem-level) backups of periodically - This lets you use smarter tools which may take a binary diff of the DB table files and not have to suck down the whole thing every time you make a backup.
The other advantage is you have a well-knwon and well-supported recovery path this way :-)

Best Answer

Related Solutions

Mysql – Postgres equivalent to MySQL’s \G

Postgresql – n easy way to partially backup Postgres

Related Topic