Results 1 to 4 of 4
  1. #1
    Join Date
    May 2009
    Posts
    2

    Unanswered: Store the structure kind of data as BLOB in a table

    Hi

    I want to load the data as a structure in table as a BLOB format.I have an idea how to load the *.JPG or some file (*.txt) into DB as below.

    Ex:

    > Create table t1(id integer,data oid);
    >Insert into t1(id,data) values (1,lo_import('path of the file'));

    Could you please give me an idea how to load binary data as a structure(for EX: By using C code & ODBC connection) into table.

    - Prakash

  2. #2
    Join Date
    Nov 2009
    Posts
    15
    I have to convert the functions from Postgre SQL to SQL Server 2005. But I am unable to find the appropriate tool. Can anybody help me?

  3. #3
    Join Date
    Nov 2009
    Posts
    1
    I want to load the data as a structure in table as a BLOB format

  4. #4
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    I'm not sure what the question was, or if there was a question. You use a bytea column to store and provided functions to work with.

    PostgreSQL: Documentation: Manuals: PostgreSQL 8.4: Large Objects

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •