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

Re: Data insert

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Postgres Admin <postgres(at)productivitymedia(dot)com>
Cc: PostgreSQL - Admin <pgsql-admin(at)postgresql(dot)org>,PostgreSQL - PHP <pgsql-php(at)postgresql(dot)org>,PostgreSQL - SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Data insert
Date: 2005-08-20 17:47:53
Message-ID: 20050820174753.GA68467@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-phppgsql-sql
On Sat, Aug 20, 2005 at 01:17:55PM -0400, Postgres Admin wrote:
> I don't have any idea how to insert the type of data into PostgreSQL. 
> Basically, it's encrypted data in which I would like that keep raw format.

If the data is binary then you could store it in a BYTEA column.  How
to get such data into the database depends on the client interface --
you could escape the data appropriately and embed it into an INSERT
statement, or you could use a parameterized query that either
transfers binary data using the PostgreSQL protocol (available in
7.4 and later) or automatically escapes the data.  See your interface
documentation for more information.

-- 
Michael Fuhr

In response to

  • Data insert at 2005-08-20 17:17:55 from Postgres Admin

pgsql-php by date

Next:From: Jim C. NasbyDate: 2005-08-23 00:57:52
Subject: Re: [PHP] Data insert
Previous:From: Postgres AdminDate: 2005-08-20 17:17:55
Subject: Data insert

pgsql-admin by date

Next:From: Don DrakeDate: 2005-08-21 19:22:25
Subject: sleep?
Previous:From: Postgres AdminDate: 2005-08-20 17:17:55
Subject: Data insert

pgsql-sql by date

Next:From: Bernard Henry VoynetDate: 2005-08-20 19:27:15
Subject: Unwanted nested dollar-quoted constants
Previous:From: Postgres AdminDate: 2005-08-20 17:17:55
Subject: Data insert

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