Thread: Plugin For Console
I was told that there's a plugin for pgAdmin3 which allows me to bring up a psql console to the server I'm connected to however I sadly can't find this plugin. Does anyone know if this exist and or how I can install this on my installation of pgAdmin3?
On Mon, Feb 6, 2012 at 12:03 PM, Francisco Leovey <fleovey@yahoo.com> wrote: > There is no need for a plugin, just click the SQl window button on the > pgAdmin3 taskbar The SQL window doesn't support \* 'psql' commands nor does it appear to support tab ahead typing. There appears to be a significant need for it versus the built-in SQL editor.
On Mon, Feb 6, 2012 at 5:08 PM, Carlos Mennens <carlos.mennens@gmail.com> wrote: > On Mon, Feb 6, 2012 at 12:03 PM, Francisco Leovey <fleovey@yahoo.com> wrote: >> There is no need for a plugin, just click the SQl window button on the >> pgAdmin3 taskbar > > The SQL window doesn't support \* 'psql' commands nor does it appear > to support tab ahead typing. There appears to be a significant need > for it versus the built-in SQL editor. The SQL window isn't intended to replicate the features of psql - it has it's own feature set. The plugin is installed by default - it should work out of the box on Windows and Mac, on Linux you may need to install psql and configure the PG Bin Path option under File -> Options to point to the directory containing the psql binary. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On Mon, 2012-02-06 at 17:37 +0000, Dave Page wrote: > On Mon, Feb 6, 2012 at 5:08 PM, Carlos Mennens <carlos.mennens@gmail.com> wrote: > > On Mon, Feb 6, 2012 at 12:03 PM, Francisco Leovey <fleovey@yahoo.com> wrote: > >> There is no need for a plugin, just click the SQl window button on the > >> pgAdmin3 taskbar > > > > The SQL window doesn't support \* 'psql' commands nor does it appear > > to support tab ahead typing. There appears to be a significant need > > for it versus the built-in SQL editor. > > The SQL window isn't intended to replicate the features of psql - it > has it's own feature set. The plugin is installed by default - it > should work out of the box on Windows and Mac, on Linux you may need > to install psql and configure the PG Bin Path option under File -> > Options to point to the directory containing the psql binary. > Completely agree on the SQL window. About the psql plugin, I had one other report telling me that it isn't available when you install pgAdmin 1.14.1. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
On Mon, Feb 6, 2012 at 8:13 PM, Guillaume Lelarge <guillaume@lelarge.info> wrote: > On Mon, 2012-02-06 at 17:37 +0000, Dave Page wrote: >> On Mon, Feb 6, 2012 at 5:08 PM, Carlos Mennens <carlos.mennens@gmail.com> wrote: >> > On Mon, Feb 6, 2012 at 12:03 PM, Francisco Leovey <fleovey@yahoo.com> wrote: >> >> There is no need for a plugin, just click the SQl window button on the >> >> pgAdmin3 taskbar >> > >> > The SQL window doesn't support \* 'psql' commands nor does it appear >> > to support tab ahead typing. There appears to be a significant need >> > for it versus the built-in SQL editor. >> >> The SQL window isn't intended to replicate the features of psql - it >> has it's own feature set. The plugin is installed by default - it >> should work out of the box on Windows and Mac, on Linux you may need >> to install psql and configure the PG Bin Path option under File -> >> Options to point to the directory containing the psql binary. >> > > Completely agree on the SQL window. > > About the psql plugin, I had one other report telling me that it isn't > available when you install pgAdmin 1.14.1. It works for me, on a fresh installation to a clean virtual machine. What I had forgotten though, is that the selected item on the treeview must be a connected database or a child object of one - otherwise the plugin is disabled because there's no way to know what database to connect to. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On Mon, 2012-02-06 at 20:29 +0000, Dave Page wrote: > On Mon, Feb 6, 2012 at 8:13 PM, Guillaume Lelarge > <guillaume@lelarge.info> wrote: > > On Mon, 2012-02-06 at 17:37 +0000, Dave Page wrote: > >> On Mon, Feb 6, 2012 at 5:08 PM, Carlos Mennens <carlos.mennens@gmail.com> wrote: > >> > On Mon, Feb 6, 2012 at 12:03 PM, Francisco Leovey <fleovey@yahoo.com> wrote: > >> >> There is no need for a plugin, just click the SQl window button on the > >> >> pgAdmin3 taskbar > >> > > >> > The SQL window doesn't support \* 'psql' commands nor does it appear > >> > to support tab ahead typing. There appears to be a significant need > >> > for it versus the built-in SQL editor. > >> > >> The SQL window isn't intended to replicate the features of psql - it > >> has it's own feature set. The plugin is installed by default - it > >> should work out of the box on Windows and Mac, on Linux you may need > >> to install psql and configure the PG Bin Path option under File -> > >> Options to point to the directory containing the psql binary. > >> > > > > Completely agree on the SQL window. > > > > About the psql plugin, I had one other report telling me that it isn't > > available when you install pgAdmin 1.14.1. > > It works for me, on a fresh installation to a clean virtual machine. > OK. > What I had forgotten though, is that the selected item on the treeview > must be a connected database or a child object of one - otherwise the > plugin is disabled because there's no way to know what database to > connect to. > Makes sense. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com