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

Re: Changing the Primary Key Column

From: Michael Ewan <michael(dot)ewan(at)intel(dot)com>
To: pdxpug(at)postgresql(dot)org
Subject: Re: Changing the Primary Key Column
Date: 2011-02-24 18:06:20
Message-ID: 4D669E1C.8010401@intel.com (view raw or flat)
Thread:
Lists: pdxpug

On 02/24/2011 10:00 AM, Rich Shepard wrote:
> On Thu, 24 Feb 2011, Michael Ewan wrote:
>
>> If you are willing to use a GUI interface, pgadmin3 is very useful in
>> making these kind of changes and it shows you the syntax of the SQL
>> command it is using.
>
> Michael,
>
>     I do GUIs when they increase efficiency (e.g., LyX rather than LaTeX in
> emacs). I need to split some columns into another table so I'll look at
> pgadmin3.


I agree 100%, when doing data extract queries, I just do psql command 
line, or a script file.  When doing schema changes, the syntax can be a 
little twitchy, so I use pgadmin3.  Now if Toad supported PostgreSQL, I 
might use that for queries also, it does all kinds of cool auto-complete 
for joins.

In response to

pdxpug by date

Next:From: Rich ShepardDate: 2011-02-24 18:25:52
Subject: Re: Changing the Primary Key Column
Previous:From: Rich ShepardDate: 2011-02-24 18:00:56
Subject: Re: Changing the Primary Key Column

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