* Automatic: A 700R4 4-speed automatic was very common.
* Manual: A 5-speed manual was also available. The exact model number would depend on the specific year and possibly other factors, but it wasn't a very wide range of options.
To know for certain what transmission *your* specific 1989 Camaro RS has, you'd need to check the vehicle's documentation (owner's manual, build sheet if available) or look at the transmission itself (usually visible under the car).