Insert hex / octal literals in a query?

From: "S(dot)Bob" <sbob(at)quadratum-braccas(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Insert hex / octal literals in a query?
Date: 2019-12-12 04:07:13
Message-ID: 676b031e-ac08-36f4-8253-c5cb266404d7@quadratum-braccas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all;

we have a client that needs us to pull data via sql and stage it in a
file with odd hex / octal characters as the field delimiter (Hex 1F or
Oct 31)

Is there an easy way to do this ?

Thanks in advance

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shrikant Bhende 2019-12-12 07:00:59 Re: Slow running query
Previous Message Min Wang 2019-12-11 19:03:01 Does PostgreSQL 11 work with FreeRADIUS 3 for database user authentication?