PostgreSQL: Import database dump (.sql) in Azure Space such as Azure Function, Azure Data Factory, ETC

Question

I have a GB PostgreSQL database dump. I need to import it into an Azure postgreSQL single server. I know the below command but I prefer the import done inside DB without command line in the hosting OS environment.

psql -U postgres -d mydatabase -f dumpfile.sql

Is there any db sql command to do the psql -f command job? For example, the MS sql server has several ways to do that (BULK INSERT, etc.) without powershell command line. Does pgSQL have similar functions?

Pratik Lad · Accepted Answer · 2022-08-01 06:45:30Z

1

To import dump file there is only option to use psql command or \i 'path file' command through command line. To avoid command line, you can use pgadmin tool to work with Azure Postgres SQL database. Steps are as follows.

Connect your Azure Postgres SQL to pgadmin.
Right click on Your Database Name.
Click on Restore.
Select file dumpfile.sql.
Click on Restore.

File will import successfully.

answered Aug 1, 2022 at 6:45

Pratik Lad

8,7282 gold badges5 silver badges15 bronze badges

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

3 Comments

Aussie Over a year ago

Is it possible to execute psql command in the Azure function Powershell? I thought pgSQL may have a statement like "restore database myDB from 'c:\db\mydb.bak'" in SQL server.

Pratik Lad Over a year ago

There is pg_restore command to restore the data into the target database from the dump file.

Aussie Over a year ago

Is there any command for .sql dump file too?

Collectives™ on Stack Overflow

PostgreSQL: Import database dump (.sql) in Azure Space such as Azure Function, Azure Data Factory, ETC

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related