Re: Navigating Databases / Tables in SQL Editor

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>, pgadmin-support(at)postgresql(dot)org
Subject: Re: Navigating Databases / Tables in SQL Editor
Date: 2012-02-08 17:26:03
Message-ID: 4F32B02B.1060700@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On 08/02/2012 17:18, Guillaume Lelarge wrote:
> On Wed, 2012-02-08 at 11:58 -0500, Carlos Mennens wrote:
>> This may seem like a really novice question however when I select my
>> database in pgAdmin3, I then click the SQL window. How can I switch
>> database connections or show / describe tables in the SQL Editor?
>
> To change connection, there is a combobox in the toolbar that allows you
> to do so.
>
> The SQL Editor cannot show or describe tables. You have to use the
> browser for that.

You can enable an option to copy the SQL for an object into the query
tool, which can be handy if you need it a lot. It's under File ->
Options -> Query Tool tab, "Copy SQL from main window to query tool".

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Anna Leslie 2012-02-08 22:42:43 login failed
Previous Message Guillaume Lelarge 2012-02-08 17:18:52 Re: Navigating Databases / Tables in SQL Editor