Here's my 2 cents.
If you have access to DTS in SQL Server 2000, it will be one convenient
solution for simple transfer.
It's a matter of creating a new task, defining the SQL Server database as
source and PostgreSQL database as destination, and clicking through. There
will be some mismatches in data types, but you can convert data using
scripts inisde the DTS task on the fly.
Regards,
Ben Kim
Developer
College of Education
Texas A&M University