Skip site navigation (1) Skip section navigation (2)

Location of a new column

From: Terry Hampton <thampton(at)limacorp(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Location of a new column
Date: 2004-04-08 12:36:37
Message-ID: 40754755.2020603@limacorp.com (view raw or flat)
Thread:
Lists: pgsql-admin
	All,

	I thought this was answered before, but I
	could not find anything in my saved email.

	I need to ALTER a table to add a new column.
	I want the new column to be between two existing
	columns,  however.     Didn't I see mention of
	an "AFTER" parameter that specified the location
	in the table where the new column should be
	placed ?    Maybe not ..........     How then,
	can I specify the location within the table,   of
	new column ?
	
		7.3  &  RH Linux



		Many thanks !

		Terry


-- 
Terry L. Hampton
Project Manager
LimaCorp, LLC   www.limacorp.com
513.587.1874



Responses

pgsql-admin by date

Next:From: Tony and Bryn ReinaDate: 2004-04-08 12:51:14
Subject: Re: Database storage bloat
Previous:From: Douglas TrainorDate: 2004-04-08 11:41:37
Subject: Re: Database storage bloat

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group