A place to breathe

Wednesday, May 8, 2019

Postgres Dump on windows 10

Recently I've been trying to do all my development on Windows 10. Fortunately, Windows Power Shell has been really cool and I kind of like it.

If you use Postgres for some reason, you might be wondering how the heck you want to dump the SQL database using PgAdmin 4.

Well, sorry to say, there hasn't been luck for me, and probably for you too.

Now, go ahead and launch your windows power shell, and type this:

PS C:\Program Files\PostgreSQL\11\bin> ./pg_dump.exe -U postgres -t   your_table_name your_database_name >> ~/my_table.sql 

You will find your SQL dump in the my_table.sql.

Have fun ! 

About Me

I'm currently a software engineer. My specific interest is games and networking. I'm running software company called Nusantara Software.