469,086 Members | 1,192 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,086 developers. It's quick & easy.

How to store binary files in the PostgreSql database table?

I want to store some pdf files in the database, What would be the datatype for the same. If anyone knows please give me the details. I am very new to the PostgreSql database.
Jul 5 '07 #1
1 7272
534 Expert 512MB
Look at the blob (Large Object) datatype.

Depending on which interface you want to use you may need to dig in into examples of using server side functions or lippq, including this sample program

Alternatively you can store your files on the disk and keep only the pathname on the database.
Many people would argue that this is a better approach.
Jul 5 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Dux | last post: by
1 post views Thread by Roderik | last post: by
reply views Thread by Ivan Horvath | last post: by
2 posts views Thread by Marcin Gil | last post: by
3 posts views Thread by Ringo Langly | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.