Suggested SQL/PostgreSQL Schema Layout

Hello,

Has IPUMS published any (Postgre)SQL schema/table layouts for using its data in database form?

We don’t have resources for this, nor am I aware of others who do. If you find anything, you are welcome to post it here in case others are interested.

I know it’s been a while now, but I built a program, ipums2db, which can generate database schema (Postges and other RDBMS supported) from an IPUMS extract DDI (e.g., “.xml“) file. You can also generate a full dump, row insertions included, assuming you have fixed-width data.