Postgresql, export a sql file to create database

Question

With MySql Workbench, I could create all tables of a database with EER-Diagram, and then do File/Export/Forward Engineer SQL Create Script to generate a sql file that creates the db plus all tables of the db. In Postgresql, with pgAdmin4 or DBeaver, I have created all tables under database/schema, is there any similar way to generate a sql file to create the db and all tables of the db?

This is usually done with the pg_dump command line tool.

Schwern
– Schwern

2020-07-19 05:25:03 +00:00
Commented Jul 19, 2020 at 5:25 — Schwern
– Schwern, Commented Jul 19, 2020 at 5:25

Thirumal · Accepted Answer · 2020-07-19 06:15:02Z

3

You export only schema without data using pg_dump in psql [terminal]:

pg_dump -U postgres -s databasename > backup.sql

or with Pgadmin4

Go to Tool -> Backup and select only schema in the Dump option.

edited Jul 19, 2020 at 6:15

answered Jul 19, 2020 at 6:10

Thirumal

9,94616 gold badges71 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

blockhead Over a year ago

it backs up as a binary file instead of a sql file with pgadmin

Ferroao Over a year ago

binary? not if I use file.sql name and "Plain" in format field

Collectives™ on Stack Overflow

Postgresql, export a sql file to create database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related