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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2011-02-24 18:25:52 | Re: Changing the Primary Key Column |
Previous Message | Rich Shepard | 2011-02-24 18:00:56 | Re: Changing the Primary Key Column |