I think you can just connect to the database with psql and issue the following:
postgres=# SHOW client_encoding; It should return something like... client_encoding ----------------- UTF8 (1 row) If your database doesn't return UTF8, you can forcefully set client_encoding ALTER DATABASE mydb SET client_encoding = UTF8 -bborie On Fri, Mar 28, 2014 at 10:43 PM, georgew <gws...@hotmail.com> wrote: > Thanks bborie, this is what I did, but no improvement: > > Microsoft Windows [Version 6.3.9600] > (c) 2013 Microsoft Corporation. All rights reserved. > > C:\WINDOWS\system32>set PGCLIENTENCODING=UTF8 > > C:\WINDOWS\system32>psql -U postgres -d NZTPU -f c:\cb09.sql > BEGIN > psql:c:/cb09.sql:2: NOTICE: table "cb09_3" does not exist, skipping > DROP TABLE > CREATE TABLE > psql:c:/cb09.sql:4: ERROR: could not load library "C:/Program > Files/PostgreSQL/ > 9.3/lib/rtpostgis-2.1.dll": unknown error 998 > LINE 1: INSERT INTO "cb09_3" ("rast","filename") VALUES ('0100000100... > ^ > psql:c:/cb09.sql:5: ERROR: current transaction is aborted, commands > ignored > unt > il end of transaction block > psql:c:/cb09.sql:6: ERROR: current transaction is aborted, commands > ignored > unt > il end of transaction block > psql:c:/cb09.sql:7: ERROR: current transaction is aborted, commands > ignored > unt > il end of transaction block > ROLLBACK > psql:c:/cb09.sql:9: ERROR: relation "cb09_3" does not exist > ........ > I tried again and the second time got the out of memory error. > What can I try next? I have searched everywhere but have not found a > suitable answer. > But as a start how can I determine what the default character set encoding > is for the server and for the client? > > > > -- > View this message in context: > http://postgis.17.x6.nabble.com/more-memory-issues-with-raster2pgsql-tp5006000p5006008.html > Sent from the PostGIS - User mailing list archive at Nabble.com. > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users