How to create sql script of postgres database schema?

Question

I want sql script of postgres 9 database schema which is not on local server. I tried pg_dump command on sql editor of pgAdmin and its not working there. I m not sure where to run that command. Please assist me with the same.... Thanks..

Bohemian · Accepted Answer · 2013-09-24T02:29:33.057

53

pg_dump is a command line utility; it isn't SQL, so it won't work in pgAdmin or anywhere else that executes SQL.

pgAdmin however does have a facility to do what you want:

Right-click on the database you want to export
Select Backup from the pop-up menu
Chose "format" Plain
Chose "plain option" Only schema

edited Sep 24 '13 at 02:29

answered Oct 18 '11 at 09:05

Bohemian

412,405
93
575
722

score 2 · Answer 2 · answered Sep 12 '16 at 17:33

2

You can also use pgAdmin tool to generate or take plain text Database Backup. You can generate plain text backup for data or schema only.

I have shared few screen shots, please visit this blog for more details.

answered Sep 12 '16 at 17:33

Anvesh

7,103
3
45
43

How to create sql script of postgres database schema?

2 Answers2

Linked