Re: binary data storage

From: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: Doug McNaught <doug(at)wireboard(dot)com>
Cc: Denis Gasparin <denis(at)edistar(dot)com>, PostgreSQL Mailing Lists-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: binary data storage
Date: 2002-04-05 21:05:55
Message-ID: 20020405210558.1BD5EFDD7@bugs.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Vie 05 Abr 2002 14:07, Doug McNaught wrote:
> Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar> writes:
> > That's the problem, at least with PHP! I can't see any reference to the
> > column of type oid in the functions, so where is it storing the data, or
> > getting the data from?
>
> Hmmm, I'm not sure where your problem is. You need to include the OID
> column in whatever table you're defining--it's not magically created
> for you.

I create a table with lots of columns, with diferent data types, and one in
particular with type oid.

Now, I want to do an insert of a row, in which I add data to all the columns
except the oid column, in which I want to insert a file. How do I make the
insert with PHP, in a way that the info of row and the file loaded in the oid
column are really in the same row.

--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués | mmarques(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Burdick 2002-04-05 21:32:04 why "Seq Scan" instead of "Index Scan" ?
Previous Message Donahue, Pat 2002-04-05 20:51:31 foreign key causing unwanted record lock