Re: Navigating Databases / Tables in SQL Editor - Mailing list pgadmin-support

From Guillaume Lelarge
Subject Re: Navigating Databases / Tables in SQL Editor
Date
Msg-id 1328721532.2245.5.camel@localhost.localdomain
Whole thread Raw
In response to Navigating Databases / Tables in SQL Editor  (Carlos Mennens <carlos.mennens@gmail.com>)
Responses Re: Navigating Databases / Tables in SQL Editor
List pgadmin-support
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.

> Usually I would be in psql and just run:
> 
> \c dbname
> 
> \d (show tables)
> 
> \d tname (describe table)
> 
> Sadly my SQL Editor doesn't support psql commands so I was wondering
> what the correct way to do this in pgAdmin3 would be...
> 

That's right. The SQL editor doesn't support any psql metacommands. The
correct way to see a description of the table is to use its browser.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



pgadmin-support by date:

Previous
From: Carlos Mennens
Date:
Subject: Navigating Databases / Tables in SQL Editor
Next
From: Raymond O'Donnell
Date:
Subject: Re: Navigating Databases / Tables in SQL Editor