weekday from timestamp?

im strugling with my dataset..

got a small pgsql db with a timestamp column in format YYYY:MM:DD
HH:MM:SS for each record

how could i possibly return day of the week for every record?

any help will be much appreciated
cheers
r