Skip site navigation (1) Skip section navigation (2)

Re: Hex representation

From: "Milen A(dot) Radev" <milen(at)radev(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Hex representation
Date: 2008-09-24 19:32:46
Message-ID: gbe4kv$e4j$1@ger.gmane.org (view raw or flat)
Thread:
Lists: 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


In response to

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-09-24 19:43:51
Subject: Re: Hex representation
Previous:From: Chirag DaveDate: 2008-09-24 19:29:59
Subject: Postgres Stats after Crash Recovery

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group