Sysobjects equivalent in PostgreSQL?

Foreign keys can be queried like this:

select t.constraint_name, t.table_name, t.constraint_type,
c.table_name, c.column_name
from information_schema.table_constraints t,
information_schema.constraint_column_usage c
where t.constraint_name = c.constraint_name
and t.constraint_type = 'FOREIGN KEY'
and c.table_name = 'mytable';

How to change postgresql Sequence number?

In general you can use the code below to set the value. (similar to
"ALTER TABLE XTable AUTO_INCREMENT = 311" in MsSQL database)

SELECT setval('schemaname.sequencename', 1467);