Thread: Feature request: associate .sql extensions with pgAdmin III

Feature request: associate .sql extensions with pgAdmin III

From
Aren Cambre
Date:
On Windows systems, it sure would be nice if files with .sql extensions automatically open in pgAdmin III when I double click on them.

It appears that pgAdmin may not register .sql extension at all, as even when I right-click and look at the Open with menu, I don't see pgAdmin III even listed.

Aren

Re: Feature request: associate .sql extensions with pgAdmin III

From
Raymond O'Donnell
Date:
On 14/01/2012 03:48, Aren Cambre wrote:
> On Windows systems, it sure would be nice if files with .sql extensions
> automatically open in pgAdmin III when I double click on them.
> 
> It appears that pgAdmin may not register *.sql* extension at all, as
> even when I right-click and look at the *Open with* menu, I don't see
> pgAdmin III even listed.

Hi there,

It works for me, on Windows 7 - pgAdmin registers itself against the
.sql extension.

Ray.


-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie


Re: Feature request: associate .sql extensions with pgAdmin III

From
"George Weaver"
Date:
>----- Original Message ----- 
>From: Aren Cambre
>To: pgadmin-support@postgresql.org
>Sent: Friday, January 13, 2012 9:48 PM
>Subject: [pgadmin-support] Feature request: associate .sql extensions with 
>pgAdmin III


>On Windows systems, it sure would be nice if files with .sql extensions 
>automatically open in pgAdmin III when I double click on them.

You can set this yourself in Windows - in Windows Explorer select Tools > 
Folder Options > File Types.  Select the .sql extension in the Registered 
files types view and then select the Change button.  If pgAdmin III does not 
show up as an option, then select Browse and go to the C:\Program 
Files\PostgreSQL\ [version] \bin folder and select pgAdmin3.exe.

>It appears that pgAdmin may not register .sql extension at all, as even 
>when I right-click and look at the Open with menu, I don't see pgAdmin III 
>even listed.

If pgAdmin III does not show up as an option, then select Browse and go to 
the C:\Program Files\PostgreSQL\ [version] \bin folder and select 
pgAdmin3.exe.

HTH,
George

>Aren 



Re: Feature request: associate .sql extensions with pgAdmin III

From
Aren Cambre
Date:
Sorry for the lack of detail.

I am using 1.14.1. It was bundled with Postgres 9.1.2. I am on Windows 7 x64.

For some reason, the pgAdmin III installer did not register .sql with pgAdmin at all. I checked this by going to Control Panel > Programs > Default Programs > Set Associations (these are the breadcrumbs at top; actual selections may be different), then click on .sql and click on the Change program button. pgAdmin III does not show up.

I just now downloaded pgAdmin III 1.14.1 from http://www.postgresql.org/ftp/pgadmin3/release/v1.14.1/win32/ and reinstalled it, and now I have the association.

Is it possible that something about being installed with Postgres is preventing the file association?

Aren

On Sat, Jan 14, 2012 at 7:39 AM, Francisco Leovey <fleovey@yahoo.com> wrote:
What version are you using? you must always indicate PgAdmin and Win versions if you want a proper answer.
It works fine for me with W7 and latest Pgadmin


From: Aren Cambre <aren@arencambre.com>
To: pgadmin-support@postgresql.org
Sent: Saturday, January 14, 2012 12:48 AM
Subject: [pgadmin-support] Feature request: associate .sql extensions with pgAdmin III

On Windows systems, it sure would be nice if files with .sql extensions automatically open in pgAdmin III when I double click on them.

It appears that pgAdmin may not register .sql extension at all, as even when I right-click and look at the Open with menu, I don't see pgAdmin III even listed.

Aren



Re: Feature request: associate .sql extensions with pgAdmin III

From
Guillaume Lelarge
Date:
On Sat, 2012-01-14 at 16:19 -0600, Aren Cambre wrote:
> Sorry for the lack of detail.
> 
> I am using 1.14.1. It was bundled with Postgres 9.1.2. I am on Windows 7
> x64.
> 
> For some reason, the pgAdmin III installer did not register .sql with
> pgAdmin at all. I checked this by going to *Control Panel* >
> *Programs* > *Default
> Programs* > *Set Associations* (these are the breadcrumbs at top; actual
> selections may be different), then click on *.sql *and click on the *Change
> program* button. pgAdmin III does not show up.
> 
> I just now downloaded pgAdmin III 1.14.1 from
> http://www.postgresql.org/ftp/pgadmin3/release/v1.14.1/win32/ and
> reinstalled it, and now I have the association.
> 
> Is it possible that something about being installed with Postgres is
> preventing the file association?
> 

You mean the PostgreSQL Windows installer? it's possible. You should ask
the EDB guys who bundled it.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
PostgreSQL Sessions #3: http://www.postgresql-sessions.org