Got PostGIS 2.0 installed on a Debian machine, with Raster enabled, and put my first image in thanks to the directions in PostGIS In Action. Here’s the auto-generated SQL in pgAdmin:

CREATE TABLE ldi_10ft
(
  rid serial NOT NULL,
  rast raster,
  CONSTRAINT ldi_10ft_pkey PRIMARY KEY ( rid ),
  CONSTRAINT enforce_srid_rast CHECK (st_srid( rast ) = 3734)
)
WITH (
  OIDS=FALSE
);

CREATE INDEX ldi_10ft_rast_gis_idx
  ON ldi_10ft
  USING gist
  (st_convexhull(rast) );

Now for some rastery fun.