Byte code, large objects, client/server, SQL, ODBC
Hi!
I am trying to find a simple and efficient way to store byte code in
postgres. The ODBC driver seems to support binary data, but not postgres.
I have looked into storing the byte code as large objects. The problem I run
into is that the functions (lo_import and lo_export) that handle large
objects are server file based. My application is running as a client towards
the postgres server over an SQL ODBC connection. To make it work properly, I
would have to store the byte code on disk and FTP it to and from the server.
It does not seem as a simple and efficient solution. Do you have any ideas
of how to solve the problem?
Thanks for your help!
/Buckis
helo list,
does anyone know where i found documentation about pl/pgsql ?
i have a variable typed date and i need to get day month and year, how can i
do that?
e.g:
function test(date)
day = day($1);
month = month ($1);
year = year($1);
thanks
Juan
On Mon, 23 Apr 2001, Juan wrote:
does anyone know where i found documentation about pl/pgsql ?
Documentation is in the Developer's Manual, at www.postgresql.org.
i have a variable typed date and i need to get day month and year, how can i
do that?
e.g:function test(date)
day = day($1);
month = month ($1);
year = year($1);
You don't need pl/pgsql for this. There are features built-in to
PG for these:
--
Joel Burton <jburton@scw.org>
Director of Information Systems, Support Center of Washington