Group Abstract Group Abstract

Message Boards Message Boards

0
|
13.6K Views
|
2 Replies
|
0 Total Likes
View groups...
Share
Share this post:

How to insert rows into SQL database with column data type bigint ARRAY[]?

Posted 11 years ago
POSTED BY: Caitlin Ramsey
2 Replies
Posted 11 years ago

Thank you, Udo. A useful suggestion, as usual. Indeed, I found that converting the nested list into a big string, and inserting into a VARCHAR column works quite nicely.

(I wouldn't want to be the one to query it on the other end, but it certainly gets the hot-potato out of my hands, and into the database!)

POSTED BY: Caitlin Ramsey

Nearest possibility at a glance to data type mapping seems to by SQLExpr, but using it one should define the data type of the corresponding attributes in the data base CLOB-like.

POSTED BY: Udo Krause
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard