Re: Hex representation - Mailing list pgsql-admin

From Milen A. Radev
Subject Re: Hex representation
Date
Msg-id gbe4kv$e4j$1@ger.gmane.org
Whole thread Raw
In response to Hex representation  (Carol Walter <walterc@indiana.edu>)
List pgsql-admin
Carol Walter написа:
> Hello,
>
> Does anyone know what the format of hex characters for postgres are?
> I'm trying to create files that contain a 0x55.  It looks to me like it
> should require a delimiter of some sort between the characters.  I don't
> know how postgres would know that the string was a hex representation
> and not just a character zero, followed by a character x, followed by a
> character 5, followed by a character 5.


http://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS

Look for "Also supported are \digits,..." in section "4.1.2.1. String Constants".


--
Milen A. Radev

pgsql-admin by date:

Previous
From: "Chirag Dave"
Date:
Subject: Postgres Stats after Crash Recovery
Next
From: "Scott Marlowe"
Date:
Subject: Re: Hex representation