Menu
Is it possible? If so how?
I can only find solution for pgadmin 3 which doesn't work for me.
857
Use the fields on the General tab to identify the schema. Use the Name field to add a descriptive name for the schema. The name will be displayed in the pgAdmin tree control. Select the owner of the schema from the drop-down listbox in the Owner field.
The phpPgAdmin administration page appears in a new window. In the left pane of the phpPgAdmin window, expand Servers, expand PostgreSQL, and then click the name of the database that you want to import the data into. On the top menu bar, click SQL. The SQL link is located between the Schemas and Find links.
Schemas in PGAdminThe “Properties” tab in the right top of the interface will display all of the extra properties that the information_schema holds on the table or column including default values, data type, and more.
Following are the step that will help you in importing all tables of your schema
1) Open pgAdmin 4
2) Navigate to Your Database Name --> Schemas --> public
3) Then right click on public
4) After clicking on public then select Restore option from DropDown Menu
5) A window will open in which you only have to give location of .sql file and leave other textboxes
6) Click Restore and leave rest on pgadmin
Note : You have to perform these steps for every single table you want to import
38
It worked like this for me:
Tools, Query Tools
.sql fileselect and the file is uploaded.sql file, press F5 or the play button above the menubar in the middle (look at the screenshot below).
132
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
