Import Error “No permission for relation”

2019-03-11 Thread Nanina Tron
I am still learning postgres and databases in general, so maybe my problem is some simple knowledge gap. I do not find anything with the same conditions with google, all I find for this error message is dealing with missing privileges and I checked for them several times. So the problem is tha

Re: Import/Export failure due to UTF-8 error in pgAdmin4 but not in pgAdmin3

2019-01-09 Thread Nanina Tron
ught if the db is encoded UTF8 the this wouldn't be a problem. best Nanina Am 08. Januar 2019 um 18:16 schrieb Dave Page : On Tue, Jan 8, 2019 at 8:55 PM Nanina Tron wrote: Hi, yes thank you I will scan the table so at least I will see the 'bad' characters. We will

Re: Import/Export failure due to UTF-8 error in pgAdmin4 but not in pgAdmin3

2019-01-08 Thread Nanina Tron
Hi, thanks for the multiple responses and interesting discussion I am struggeling to keep up with all the new information. I double checked, all settings I could find and the .csv files I want to import. Everything is manually, or at creation of the db set to UTF8. I tried to copy one of th

Import/Export failure due to UTF-8 error in pgAdmin4 but not in pgAdmin3

2019-01-07 Thread Nanina Tron
Hi, I am pretty new to PostgreSQL so I might just miss something basic here. My problem is that, I cannot import or export some of the tables in my db with pgAdmin4, as it raises the “ERROR: unvalid byte-sequenz for coding »UTF8«: 0xdf 0x67“”. The table was originally created with Excel and im