Re: Nicer dump files?

On Wed, 2002-09-25 at 18:54, Gerhard Häring wrote:
> 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?
>

I guess you could write some type of script to replace the values,
though I don't see much advantage in that.

> Another somehow related question:
>
> Are there any db design tools like Sybase PowerDesigner that support
> PostgreSQL? Perhaps in a more reasonable price range?
>

I'm not overly familiar with PowerDesigner, but I use CASE Studio 2 and
it works pretty well.  There is a list of other tools at
http://techdocs.postgresql.org, look for ERD and/or Case tools.

Robert Treat