Getting some sample data to test against is somewhat tedious. Gladly enough the pgfoundry group has created some sample databases which are free to download
http://pgfoundry.org/projects/dbsamples/
In the examples here I will try to use The Pagila database as much as possible.
So install it, just download from location above - and then unzip.
pagila-data.sql
pagila-fulltext.sql
pagila-schema.sql
We now need to execute the scripts into Postgresql. I tried with the admin interface of course. I needed some tweaking of it - some row about language didn't work, I just removed it and ran it again and it seems ok.
However the data file didn't work at all. For that see the separate article on loading sql files into Postgresql
