Re: Help me!

From: Bhuvan A <bhuvansql(at)yahoo(dot)com>
To: Dieudonne Nanga <nanga(at)compilion(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Help me!
Date: 2002-04-17 05:29:15
Message-ID: Pine.LNX.4.20.0204171057180.2528-100000@Larry
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On Apr 16, Dieudonne Nanga wrote:

> How do i insert a file in the database?

You mean large objects?
If yes, try

# select lo_import('<filename>');

this will return a OID.
and to access the same, try

# select lo_export(<oid>, '<filename>');

>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

In response to

  • Help me! at 2002-04-16 14:22:25 from Dieudonne Nanga

Browse pgsql-admin by date

  From Date Subject
Next Message Jean-Arthur Silve 2002-04-17 07:31:10 Vacuum blocking...
Previous Message Andy Ruhl 2002-04-17 03:51:48 Re: Postgresql on win2000