From: | "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> |
---|---|
To: | Martin Schulze <joey(at)infodrom(dot)north(dot)de> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: More PostgreSQL stuff |
Date: | 1998-10-02 07:20:38 |
Message-ID: | 199810020720.IAA07948@linda.lfix.co.uk |
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 ',...
>
> . 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
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Schulze | 1998-10-02 11:17:34 | Re: More PostgreSQL stuff |
Previous Message | Oliver Elphick | 1998-10-02 07:20:36 | Re: More PostgreSQL stuff |