Hi PFC,
the generate_series() seems to be the right thing I need in my scenario
but I didn't figure out how to create a SELECT stattement that will
contain sorted main_table.id in first column and generated series in
second column which I would use to update the main_table.position. Is it
possible
Penchal,
Is /tmp folder present and is the postgres user
having read/write file permissions in /tmp folder.
I was successfully able to copy a table to a file
in /tmp folder on my machine .
Regards,Gourish SingbalSoftware EngineerZEDO Inc - Customer-Fit
Ad Serving Worldwide.[EMAIL PROT
Penchal,
The ERROR u mentioned in your earlier email
describes itself . It says your
"could not open file /tmp/penchal.out
for writing: no such file or
directory.."
I used the same command you used
:-
Copy
to /tmp/filename.out
So i suggest that u check if ur able
to write/re
