#!/bin/bash

# To be run on a machina that can access udd.debian.org, currently one
# of {alioth,merkel}.debian.org.  See
# http://wiki.debian.org/UltimateDebianDatabase for more info.

query="
select * from popcon;
";
psql="/usr/lib/postgresql/8.3/bin/psql service=udd"

$psql -t -A -F "	" -c "$query"

#this script insert a spurios entry of the form "_submissions        80936"

# returned columns are:
#
# udd=> \d popcon
# package | text    | not null
# insts   | integer | 
# vote    | integer | 
# olde    | integer | 
# recent  | integer | 
# nofiles | integer |