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