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