in today “waiting for 8.4" i will show you 3 new patches. all of them add new functionality to psql – the most common tool to access postrgesql database.
Tag: postgresql
keyboard shortcuts in psql
there is this quite old, but pretty functional concept: keyboard shortcuts.
you know it – you press ctrl-s, and your editor saves currently-edited file.
my problem is that there are some standard cases when i would really love to have this ability in psql. but psql doesn't support it. or does it?
waiting for 8.4
another new, cool feature commited by tom lane: “Support statement-level ON TRUNCATE triggers."
original patch was submitted by simon riggs, and tom commited it today/yesterday (depending on time zone).
smtp + sql = more than it seems so (part 9)
previously, we talked about procmail filters in exim+sql system. today we will add some nifty aliases capabilities.
Continue reading smtp + sql = more than it seems so (part 9)
waiting for pg 8.4
on sunday, 23rd of march, tom lane commited another new-feature patch. this new patch was from brendan jurd, and adds quote_nullable() function:
waiting for pg 8.4
yesterday, tom lane committed another great feature. actually it's so great, that i really wonder how could i live without it earlier.
patch came from itagaki takahiro, and was heavily modified by tom. what it does?
getting multiple values from sequences
there are this situations where you need (or you think you need) to get multiple values from sequence.
for example – you're importing lots of data: some objects, some objects which relate to base objects, and so on.
of course you can do it all with simple inserts, and currval, but it would be rather slow:
smtp + sql = more than it seems so (part 8)
last time, i showed how to add automatical filtering of mails. and i told you that i will show another way.
Continue reading smtp + sql = more than it seems so (part 8)
smtp + sql = more than it seems so (part 7)
in previous part of this howto we setup autoresponder/vacation system.
additionally i promised to show how to filter user mails.
Continue reading smtp + sql = more than it seems so (part 7)
waiting for pg 8.4
today (2008-03-10) magnus hagander commited patch which adds new, quite handy functionality: “enum type for guc parameters".