The 400 column table I, personally, saw in production was from a data warehouse. The 1190 column table is from another team's effort at building a warehouse.

Interestingly, PostgreSQL was a good pick:

Max Columns per table of selected db servers
--------------------------------------------
DB2 UDB Max Columns per table: 1012
Oracle Max Columns per table: 1000
MS Sql Server Max Columns per table: 1024
PostgreSQL: 1600