raster2pgsql -s 4236 -t 100x100 -I -C -F dem*.* public.dem | psql -d mydb
But all the rasters will be loaded into the same table, splited into 100x100 tiles. If you load ten 1000x1000 rasters, you end up with a table of 1000 rows.
A blog on spatial analysis, raster management in PostGIS and other related things.
raster2pgsql -s 4236 -t 100x100 -I -C -F dem*.* public.dem | psql -d mydb