Postgresql import bak file into database in windows

preview_player
Показать описание
Import Bak file into Postgresql in windows system

Рекомендации по теме
Комментарии
Автор

C:\Program Files\PostgreSQL\15\bin>psql -U postgres -p 5433 -d devaprender <
Password for user postgres:
ERROR: syntax error at or near "MSSQLBAK"
LINE 1: MSSQLBAK☻

FernandoSapotec
Автор

Hi GK Techy,

Thank you for taking the time to post this video.

I encountered the following error. Your help is appreciated. :)

C:\Program Files\PostgreSQL\13\bin>psql -U postgres -d adventureWorks2019 < C:\AdventureWorks2019.bak
Password for user postgres:
ERROR: syntax error at or near "TAPE"
LINE 1: TAPE☻

bensonchua
Автор

THX MAN, I HAVE BEEN SEARCH FOT THIS, NICE JOB

enrico
Автор

When execute psql -U dbusername -d databasename databasefile.bak, I get error
ERROR: invalid byte sequence for encoding "UTF8": 0x9d
invalid command \
ERROR: invalid byte sequence for encoding "UTF8": 0x87

what should i do, thx b4

aimans