New answers tagged

4

You can specify the individual columns to fill in the COPY command: COPY table_name [ ( column [, ...] ) ] FROM { 'filename' | STDIN } [ [ WITH ] ( option [, ...] ) ] (http://www.postgresql.org/docs/9.1/static/sql-copy.html) Therefore, specify your CSV columns explicitly in the COPY, leaving out the bigserials column.


0

You may make take the advantage of OBJECT IDLETIME command, which returns the number of seconds since the object stored at the specified key is idle (not requested by read or write operations). example code as follows: #!/bin/sh redis-cli -p 6379 keys "*" | while read LINE ; do val=`redis-cli -p 6379 object idletime $LINE`; if [ $val -lt $((30 * 24 * 60 * ...



Top 50 recent answers are included