Question: postgresql how to create database from sql file?
Answer: Step 1) Open the SQL Shell. Step 2) Press enter five times to connect to the DB. Step 4) Enter command \l to get a list of all databases. Step 1) In the Object Tree, right click and select create a database. Step 4) The right pane gives you the SQL used to create the Database.