search for: pktestdf

Displaying 1 result from an estimated 1 matches for "pktestdf".

2010 Sep 18
0
Saving long character variable to database saves timestamp instead
...get a timestamp saved to the database instead. Is there any way to extend the number of characters that a text variable can receive? Here are the details of my case (simplified): I'm using PostgreSQL to create a table CREATE TABLE testdf ( numchar bigint NOT NULL, chars text, CONSTRAINT pktestdf PRIMARY KEY (numchar) ) WITH ( OIDS=FALSE ); ALTER TABLE testdf OWNER TO postgres; Then in R I create a table with long character variables: > testdf <- data.frame(matrix(NA, 2, 2)) > names(testdf) <- c("numchar", "chars") > testdf$numchar <- c(30000, 35000)...