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