Hi, habe ein Problem mit meinen Postgresql…
Also nachdem ich es erfolgreich installiert hatte, habe ich eine neue Login-Regel erstellt mit Benutzer: ‘schueler’ und ein Passwort angegeben.
So dann hab ich jetzt ein SQL-Skript mit dem Namen vhs.sql das ich gerne in die Datenbank mittels der Befehlszeile einspielen möchte.
Als nächstes habe ich die Befehlszeile von PostgreSQL8.2 gestartet und folgenden Befehl eingegeben:
C:\Programme\PostgreSQL\8.2\bin>psql vhs < C:\vhs.sql -U schueler -W
Passwort für Benutzer schueler: ***
So und jetzt bekomm ich meinen Fehler und weiß nicht warum:
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
ERROR: invalid byte sequence for encoding "UTF8": 0xf6736973
TIP: This error can also happen if the byte sequence does not match the encodin
g expected by the server, which is controlled by "client_encoding".
ERROR: invalid byte sequence for encoding "UTF8": 0xf6736973
TIP: This error can also happen if the byte sequence does not match the encodin
g expected by the server, which is controlled by "client_encoding".
INSERT 0 1
INSERT 0 1
ERROR: invalid byte sequence for encoding "UTF8": 0xfc
TIP: This error can also happen if the byte sequence does not match the encodin
g expected by the server, which is controlled by "client_encoding".
INSERT 0 1
INSERT 0 1
INSERT 0 1
ERROR: invalid byte sequence for encoding "UTF8": 0xe46e6e
TIP: This error can also happen if the byte sequence does not match the encodin
g expected by the server, which is controlled by "client_encoding".
INSERT 0 1
ERROR: invalid byte sequence for encoding "UTF8": 0xe46474
TIP: This error can also happen if the byte sequence does not match the encodin
g expected by the server, which is controlled by "client_encoding".
INSERT 0 1
INSERT 0 1
ERROR: invalid byte sequence for encoding "UTF8": 0xe46666
TIP: This error can also happen if the byte sequence does not match the encodin
g expected by the server, which is controlled by "client_encoding".
ERROR: invalid byte sequence for encoding "UTF8": 0xd66c
TIP: This error can also happen if the byte sequence does not match the encodin
g expected by the server, which is controlled by "client_encoding".
INSERT 0 1
INSERT 0 1
ERROR: invalid byte sequence for encoding "UTF8": 0xf66e6967
TIP: This error can also happen if the byte sequence does not match the encodin
g expected by the server, which is controlled by "client_encoding".
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1