[SQL] lo_import for storing Blobs

I need to store a binary file in a database. I use a cgi writed in shell to do it. So I can use Postgres user to execute the cgi. How can I store a binary file in a database with a cgi ? Thanks a lot. Laurent. ---(end of broadcast)--- TIP 2

[SQL] varbit question

(n) but if I use the (n) argument, the script fails. I can only use varbit alone. How do I get around that? Also, will ResultSet.getBytes() (I'm talking Java here) return an array of bytes with a field defined as varbit? How large will the field be? Thanks, L -- Laurent Duperval <mailt

[SQL] UPDATE with concatenate

Hy, I try to update a table:col with take the valueof this col and concatenate it with $val. I don't want to select all value of table:col and addition $val at each one I try : UPDATE table SET col .= '$val' But it doesn't work, any suggestion ? pat ---(end of broa

[SQL] optimizing select ... not in (select ...)

) -- Laurent Martelli [EMAIL PROTECTED] http://www.bearteam.org/~laurent/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] Re: Donations?

a request on the site, telling how much you are willing to spend to see it developped. Other users can join you so that's more money for the developpers. Developpers can submit proposals. You choose one, commit money on it, the developper does the work, you pay him and everybody's happy

[SQL] Re: optimizing select ... not in (select ...)

>>>>> "Tomas" == Tomas Berndtsson <[EMAIL PROTECTED]> writes: Tomas> Laurent Martelli <[EMAIL PROTECTED]> writes: >> I have this query : >> >> select distinct on (Pictures.PictureID) * from Pictures where >> Picture

[SQL] Function and insert

Hi, I want to do a function that insert a row on a table like : CREATE FUNCTION ajout_secu(INT4) RETURNS OID AS 'INSERT INTO test_2 VALUES($1);' LANGUAGE 'SQL'; PG refuse to accept the type returns oid as the function is not a SELECT. What can I do ? thanks for your help, LP --

[SQL] Select Match on PostgreSQL.

running MySQL as root') AS score -> FROM articles WHERE MATCH (title,body) AGAINST -> ('Security implications of running MySQL as root'); But how can I do it on PostgreSQL where Match syntax is not accepted ? Thanks to help me. Regards. La

[SQL] Information about the command SQL " create synonym".

Hello ! I am trying to find some informations about the SQL command "create synonym". The command "create synonym" does not exit in the Postgres database. I had tested with the latest version (postgres8.0 beta3) and this command is not present. I supposed that this command "create synnonym" is