4

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+
Improve this question
3
  • I've read that and as I said I got an error. Commented Dec 14, 2013 at 7:28
  • Command \d (not /d!) works fine for me on Windows in psql console Commented Dec 14, 2013 at 7:33
  • I don't have access to psql. database is on server and I just can see databases through phppgAdmin Commented Dec 14, 2013 at 7:36
Related questions
638
"use database_name" command in PostgreSQL
737
Import SQL dump into PostgreSQL database
410
Cast from VARCHAR to INT - MySQL
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.