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.Elphick@lfix.co.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