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)...