Nicer dump files?

Ok, now I have played with psql and created a few tables. If I use
pg_dump I get relatively awkward scripts that look like:

       CREATE TABLE "person" (
        "id" integer DEFAULT nextval('"person_id_seq"'::text) NOT NULL,
        "login" character varying(20) NOT NULL,
        ...

Is there a way to get a nicer looking script that will look like:

    create table person (
        id int serial,
        login varchar(20) not null
        ...

? IOW similar to the commands one would use as a human to create the
tables?

Another somehow related question:

Are there any db design tools like Sybase PowerDesigner that support
PostgreSQL? Perhaps in a more reasonable price range?

Thanks,

-- Gerhard