Hi. I'm using Postgresql 9.0.5, and the connection is made via pgbouncer.
I create a temporary table, and then want to import data into this
table via a COPY command. Yet, this just created table is not being
recognized. What's up?
From my terminal:
mydb=#
mydb=# create temporary table vl (
alias varchar(35)
,dates timestamp without time zone
,referers text null
);
CREATE TABLE
Time: 1.871 ms
mydb=# copy vl from '/backup/data.txt' WITH DELIMITER AS '|';
ERROR: relation "vl" does not exist
mydb=#
Weird! Welcome any thoughts.
Thanks