Is there something like show create database in postgres?

Asked Dec 14 '13 at 07:22

Active Dec 14 '13 at 07:33

Viewed 525 times

I want to use something like Mysql command to show me the structure of postgres tables in a database, Is there a way for it? I main goal is to create an exact copy of the table in another database with postgres sql.

I tries /d+ command, but got the following error:

ERROR:  syntax error at or near "\"
LINE 1: \d

My OS is windows XP SP3.
I've read the following post but gain no success:
postgres question about descibe table

EDIT: \d+ command output on windows :

ERROR:  syntax error at or near "\"
LINE 1: \d+

edited May 23 '17 at 12:33

Community

asked Dec 14 '13 at 07:22

Alireza

6,497
13
59
132

I've read that and as I said I got an error. – Alireza Dec 14 '13 at 07:28
Command `\d` (not `/d`!) works fine for me on Windows in `psql` console – mvp Dec 14 '13 at 07:33
I don't have access to psql. database is on server and I just can see databases through phppgAdmin – Alireza Dec 14 '13 at 07:36

Is there something like show create database in postgres?

0 Answers0