Ihsan Ahmed · Jun 27, 2020 go to post

PostgreSQL might support multiple line Execute for sure, in DBeaver you can use Alt+X by highlighting the lines to be executed, please make sure you have the semi colon at the end of each SQL.

Ihsan Ahmed · Jun 28, 2020 go to post

Hi, Thank you for your response.. I am writing a routine to upload some data to the table, the language I am looking to upload the data is actually arabic, but it inserts gibrish.. any idea how I could support Arabic inserts.. if i insert directly through the DBMS Inserts.. it goes through perfectly... so this is something to do with the reads of the file...any help in this is greatly appreciated.

Ihsan Ahmed · Jun 28, 2020 go to post

great, it worked... did the below

Do stream.TranslateTableSet(“UTF8”).

Thanks