Re: More PostgreSQL stuff

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 ',...
>
> . 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?

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"Set your affection on things above, not on things on
the earth." Colossians 3:2