PostgreSQL, copy from a file as non-superuser
testdb=> COPY weather FROM ‘/tmp/input_data.txt’;
ERROR: must be superuser to COPY to or from a file
HINT: Anyone can COPY to stdout or from stdin. psql’s \copy command also works for anyone.
So, how do we copy?
there is more than a way to skin a cat…
CREATE TABLE table1 (
code char(5),
name char(10)
);
synack@deimos db $ cat /tmp/input_data.txt
1,kamchi
2,mahabat
3,kamila
postgres@deimos [...]
WordPressDash – Dashboard widget to post to wordpress
I’m using WordPressDash, which is a Dashboard widget to get this post posted on my WP
macbook and mac os x
Recently got a brand new Intel-based MacBook, and these days are getting myself familiar with a new OS – Mac OS X… Here are some of the links that you might check out:
http://en.wikipedia.org/wiki/Mac_OS_X
http://docs.blacktree.com/quicksilver/overview
http://www.coconut-flavour.com/coconutwifi/index.html
http://www.apple.com/downloads/
Later on will try to put together some text about my experience… For now, trying to get my usual stuff running on gentoo [...]