| From: | Scott Frankel <frankel(at)circlesfx(dot)com> |
|---|---|
| To: | Shoaib Mir <shoaibmir(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: add column specify position |
| Date: | 2010-02-03 20:33:20 |
| Message-ID: | 566194E1-70D7-4B06-B900-D1037FDE6C26@circlesfx.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Excellent! Thanks for providing the link. I think the 'add columns
and move data' option would best fit my needs.
Thanks!
Scott
On Feb 2, 2010, at 11:44 PM, Shoaib Mir wrote:
> On Wed, Feb 3, 2010 at 4:14 PM, Scott Frankel
> <frankel(at)circlesfx(dot)com> wrote:
>
> Hi all,
>
> Is it possible to specify a position when adding a column to a table?
>
>
> Not possible, but have a read of http://wiki.postgresql.org/wiki/Alter_column_position
> and look at the alternative options.
>
> --
> Shoaib Mir
> http://shoaibmir.wordpress.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wang, Mary Y | 2010-02-03 21:16:15 | Re: PQendcopy:resetting connection Problem and Cannot insert a duplicate key into unique index |
| Previous Message | Andrej | 2010-02-03 19:50:40 | Re: |