| 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: | Whole Thread | Raw Message | 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
>
| 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 |