From: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
---|---|
To: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk>, Martin Schulze <joey(at)infodrom(dot)north(dot)de> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | RE: [GENERAL] Re: More PostgreSQL stuff |
Date: | 1998-10-02 15:34:33 |
Message-ID: | F10BB1FAF801D111829B0060971D839F447DFD@cpsmail |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Martin Schulze wrote:
> >Hi Oliver!
> >
> >I have some more questions wrt. PostgreSQL.
>
> Forwarded to PostgreSQL list, since I cannot answer them.
>
> > . Why does pg_dump only write some SQL commands in capital letters
> > but not all? I wonder if that's intentional. Please look at
> the
> > following excerpt. I would have expected CHAR, VARCHAR, INSERT
> > INTO, VALUES etc. to occur in capital letters.
> >
> > CREATE TABLE zeitungen (name char(30), typ char(10), ...
> >
> > insert into zeitungen values ('Mallorca Immobilien
> ',...
CAPS/no-CAPS are just a preference of the coder's of pg_dump. If you
want you can go through the source of pg_dump and uppercase all the SQL
and recompile.
> >
> > . I wonder how one could add or remove columns from existing
> tables.
> >
> > With mSQL this was possible with a trick. You had to dump the
> > whole table but you could tell the dump program to add dummy
> fields
> > or to leave out existing fields. Is there any such possibility
> > with PostgreSQL?
You can do a select into a temp table with the added columns, drop the
old table the rename the temp table to the old name. You'll also have
to recreate your indexes, triggers, and rules.
-DEJ
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Schulze | 1998-10-02 15:39:57 | Re: [GENERAL] Re: More PostgreSQL stuff |
Previous Message | Martin Schulze | 1998-10-02 11:17:34 | Re: More PostgreSQL stuff |