| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: Navigating Databases / Tables in SQL Editor |
| Date: | 2012-02-08 17:18:52 |
| Message-ID: | 1328721532.2245.5.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond O'Donnell | 2012-02-08 17:26:03 | Re: Navigating Databases / Tables in SQL Editor |
| Previous Message | Carlos Mennens | 2012-02-08 16:58:49 | Navigating Databases / Tables in SQL Editor |