471,595 Members | 1,913 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,595 software developers and data experts.

How to insert values in BYTEA?

Hi everyone,

I have a table with a bytea-column:

CREATE TABLE picture(
id int primary key,
preview bytea NOT NULL);

How can I insert a value in the bytea-column
'preview'? The function 'lo_import()' does only work
for oid. But what is about bytea?

If somebody has any suggestions or ideas, that would
be great.

Thanks a lot in advance,

Oliver


__________________________________________________ _________
Gesendet von Yahoo! Mail - Jetzt mit 100MB Speicher kostenlos - Hier anmelden: http://mail.yahoo.de

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #1
0 3647

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by mPath Records | last post: by
4 posts views Thread by Morten Goodwin Olsen | last post: by
48 posts views Thread by Edwin Quijada | last post: by
1 post views Thread by Baldur Norddahl | last post: by
2 posts views Thread by Alvar Freude | last post: by
5 posts views Thread by Louis LeBlanc | last post: by
4 posts views Thread by David Garamond | last post: by
7 posts views Thread by C G | last post: by
reply views Thread by rich | last post: by
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by Anwar ali | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.