Postgres Pro
Downloads
Home   >   mailing lists

Re: How can I insert a UTF-8 character with psql? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: How can I insert a UTF-8 character with psql?
Date
Msg-id Pine.LNX.4.44.0306161409490.2751-100000@peter.localdomain
Whole thread Raw
In response to How can I insert a UTF-8 character with psql?  (Roland Glenn McIntosh <roland@steeltorch.com>)
List pgsql-general
Tree view 
Roland Glenn McIntosh writes:

> I would like to insert a EuroSign as two byte character number 20AC.
> Is there a way I can do this from an ISO-8859-1 (latin1) terminal emulator via the psql tool?

Set the client encoding to latin9 and enter it normally.

> Is there an entity scheme?

Not in the way you imagine, but there should be.

--
Peter Eisentraut   peter_e@gmx.net

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: LC_COLLATE=es_MX in PgSQL 7.3.2
Next
From: Greg Stark
Date:
Subject: Re: full featured alter table?