Changing a database's compression level does not change the compression level of existing tables in the database; only tables you create after you alter the database inherit the new compression level.
alter database database_name […] set [[,] compression = {none | row | page}]
See the Reference Manual: Commands.
alter database pubs2 set compression = page