Re: Changing the Primary Key Column

Why make it so hard?

begin;
SELECT * INTO new_table FROM old_table;
DROP old_table;
CREATE old_table ( new definition );
INSERT INTO old_table SELECT col1,col2,col3,etc. FROM new_table;
DROP new_table;
commit;

On Feb 23, 2011, at 16:22, Rich Shepard wrote:

> On Wed, 23 Feb 2011, Michael Ewan wrote:
>
>> Yes that would be a good idea, and was implied in any suggestion of dropping tables. ;-)
>
>> Just be advised, pg_dump dumps to a copy from stdin: format with tab delimiters.
>
> I read the pg_dump man page but did not learn how to specify an
> alternative format that would allow me to re-arrange column order, drop the
> unwanted column, and so on. Next step is looking at the 9.0.x docs for
> pg_dump.
>
> Rich
>
> --
> Sent via pdxpug mailing list (pdxpug(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pdxpug