databasepostgresqlfilepgadminquick.db

How to import .db file to pgAdmin 4?

I want to import a file with .db extension into pgAdmin 4, how can I do that? It is not a .tar file but a .db file. Is there any way to import this database?

Thanks in advance for the help.

Solution

  • Here is how you can import a PostgreSQL database in PGAdmin 4.

    1. Right Click on database(which you want to export).

    select database

    1. Click on the browse file button

    file button

    1. Select destination & Give file name

    select destination

    1. Click Save, then click on Backup.

    This will save your file in SQL format, which you can use later to export the database.

    As far as I know, it is impossible(till now) to get an import file with .db extension but, Using this method you can get a backup file of your database with .sql extension.

    Also, you can use the pgdump command to get a database backup.