Help for this page

Select Code to Download


  1. or download this
    % cat <<_EOC | psql test
CRAETE TABLE rawdata (
...
        voted INTEGER DEFAULT 0
);
_EOC
  2. or download this
    % perl -nle 'printf "INSERT INTO rawdata VALUES (%d, %d, %d);\n", spli
+t' < data.txt | psql test
  3. or download this
    % cat <<_EOSQL | psql test
-- Use transactions so all temporary views are distroyed after rollbac
+k.
...

ROLLBACK;
_EOSQL