USSS Agent Frank Horrigan (Clint Eastwood) uses a Smith & Wesson Model 19 at the start of the film to arrest Mendoza (Tobin Bell) and kill his two henchmen. Later on, A Secret Service agent holds a Model 19 on Horrigan before he disarms him.
SIG-Sauer P228
USSS Agents Frank Horrigan (Clint Eastwood) and Al D'Andrea (Dylan McDermott) carry SIG-Sauer P228 pistols as their sidearms in the film, as do all the other Secret Service Agents.
We can see one of these small spanish pistols at the beginning of the movie. It is a 1911 clone scaled down to a pocket pistol and built to fire .380 ACP.
We see John Malkovich's character constructing this two shot, reloadable handgun in the movie. The weapon is used to great effect blowing a toy boat out of the water and killing the two duck hunters mid-way through the flick. Though seen only briefly the weapon appears to take .38 Special rounds. (Looks like .32 S&W cartridges to me.)
When the DC Metropolitan Police attempted to arrest the assassin, the DC ERT officers were armed with Uzi submachine guns with stock extended. Unfortunately, it turned out that the assassin scrambled the trace and lead the Secret Service and the police to a completely different address.The IMI Uzi is also seen when the secret service agents are rushing the president out of the hotel after the assassination attempt (the agents by the kitchen door have them).