In many other db systems you can use built in functions to check to see if
an object exists in the db...
For example, in Sybase, you can use the object_id function to check to see
if an object exists...
if object_id('some table, view, stored procedure, etc. name') is not null
-- perform some action, like drop a stored proc
else
-- perform some other action
End -- if
Does an equivalent function exist in Postgres?
Furthermore, where should I look to find the list of such built-in
functions?