dump partial data from postgresql table
For example I need to dump 1000 records from table my_table:
1 | COPY(SELECT * FROM my_table 1000) to '/path/to/my_table.sql' |
For details about COPY command, check PostgreSQL Document.
For example I need to dump 1000 records from table my_table:
1 | COPY(SELECT * FROM my_table 1000) to '/path/to/my_table.sql' |
For details about COPY command, check PostgreSQL Document.
To use xapian in virtualenv, you could manually compile and install into your virtualenv environment:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | export VENV=$VIRTUAL_ENV mkdir $VENV/packages && cd $VENV/packages ... |
I got following message when doing a yum check-update:
rpmfusion-free-updates | 3.3 kB 00:00
Not using downloaded repomd.xml because it is older than what we have:
Current : Sat Jan 28 18:19:20 2012
Downloaded: Mon Jan 9 ...
First thing bothered me is that when using postgresql and psycopg2.4.4, run test will get following errors:
psycopg2.ProgrammingError: autocommit cannot be used inside a transaction
This turns out is a incompatible problem with django and newer version ...
在VMware vSphere上安装linux虚拟机,在配置内核的时候出了差错,导致重启之后出现kernel panic,无法正常启动,想使用光盘引导但是启动速度太快了,总是来不及进BIOS,后来发现其实在虚拟机配置文件中有选项可以强制在启动的时候进入BIOS设置画面,不多说了,直接上图:

最新评论
iwzmvtr payday advance 3265 car insurance rates bCrSiX payday loans ...
Hey dump partial data from postgresql table I enjoy your ...
forgot 'limit' inside sub select
真牛!看了blog主的文章,收获不少!谢了!
hi,很高兴来到你的博客,看看目前大家还是有很多共同的关注点啊.收藏了.多多交流.呵呵