Re: [GENERAL] connect using quirrel sql client

2013/12/20 Adrian Klaver : > On 12/20/2013 01:08 AM, Arindam Mondal wrote: >> >> Hi , >> please let me know how I can connect postgresql using squirrel sql >> client 3.4.0. > > > Make sure you have the Postgres JDBC driver: > > http://jdbc.postgresql.org/download.html > > Configure SQuirrel: > > h

Re: [GENERAL] connect using quirrel sql client

On 12/20/2013 01:08 AM, Arindam Mondal wrote: Hi , please let me know how I can connect postgresql using squirrel sql client 3.4.0. Make sure you have the Postgres JDBC driver: http://jdbc.postgresql.org/download.html Configure SQuirrel: http://squirrel-sql.sourceforge.net/index.php?page=sc

[GENERAL] connect using quirrel sql client

Hi , please let me know how I can connect postgresql using squirrel sql client 3.4.0. Thanks & Regards Arindam Mondal

Re: [GENERAL] Connect postgres to SQLSERVER

On 17/09/2013 19:05, Agustin Larreinegabe wrote: HI, Is there a way to connect to a sqlserver like dblink? I just need to execute a Procedure in sqlserver when something happen -- Gracias - Agustín Larreinegabe If all you want to do is trigger a single stored proc, one option

Re: [GENERAL] Connect postgres to SQLSERVER

On Wed, Sep 18, 2013 at 12:11 AM, Igor Neyman wrote: > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Agustin Larreinegabe > Sent: Tuesday, September 17, 2013 2:06 PM > To: PostgreSQL mailing lists > Subject: [GENERAL] Conn

Re: [GENERAL] Connect postgres to SQLSERVER

From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Agustin Larreinegabe Sent: Tuesday, September 17, 2013 2:06 PM To: PostgreSQL mailing lists Subject: [GENERAL] Connect postgres to SQLSERVER HI, Is there a way to connect to a sqlserver like dblink

Re: [GENERAL] Connect postgres to SQLSERVER

On 9/17/2013 11:05 AM, Agustin Larreinegabe wrote: Is there a way to connect to a sqlserver like dblink? I just need to execute a Procedure in sqlserver when something happen postgresql *is* a sql server.or do you mean Microsoft SQL Server ? -- john r pierce

[GENERAL] Connect postgres to SQLSERVER

HI, Is there a way to connect to a sqlserver like dblink? I just need to execute a Procedure in sqlserver when something happen -- Gracias - Agustín Larreinegabe

Re: [GENERAL] connect local pgAdmin III to remote postgres server

On 08/05/2012 12:21, gdhia wrote: > > postgresql.conf has the changed value: > #listen_addresses = '*' You need to uncomment this line for it to take effect. Remove the '#' from the start of the line, and then restart (or maybe just reload? - not sure) the server. Ray. -- Raymond O'Donnell ::

[GENERAL] connect local pgAdmin III to remote postgres server

Hi all, I have a Debian server on which is installed Postgresql, with a database. I have installed pgAdmin III on my computer (Win 7) and I try to communicate with postgres on my server to display it. on my server, using this code tells me the DB installed: postgres=# select datname from pg_dat

Re: [NOVICE] [GENERAL] Connect to postgresql database using Perl

On Wed, Mar 31, 2010 at 3:25 AM, dipti shah wrote: > Thanks Guys. DBI works fine. I have written below code but it executes only > on the server where I installed postgresql. Is there any way to run this > code from remote host. I get an error when trying to run it from remote > host. I think it i

Re: [GENERAL] Connect to postgresql database using Perl

That was cool ! Thanks a ton. Got my things done. On Wed, Mar 31, 2010 at 1:13 PM, John R Pierce wrote: > dipti shah wrote: > >> Thanks Guys. DBI works fine. I have written below code but it executes >> only on the server where I installed postgresql. Is there any way to run >> this code from re

Re: [GENERAL] Connect to postgresql database using Perl

dipti shah wrote: Thanks Guys. DBI works fine. I have written below code but it executes only on the server where I installed postgresql. Is there any way to run this code from remote host. I get an error when trying to run it from remote host. I think it is obvious because in below code there

Re: [GENERAL] Connect to postgresql database using Perl

Thanks Guys. DBI works fine. I have written below code but it executes only on the server where I installed postgresql. Is there any way to run this code from remote host. I get an error when trying to run it from remote host. I think it is obvious because in below code there is no information wher

Re: [GENERAL] Connect to postgresql database using Perl

Hello 2010/3/31 dipti shah : > Hi, > > Could anyone please provide me an example to connect to a postgresql > database using Perl language and accessing the tables, schemas, and other > postgresql objects. > http://www.felixgers.de/teaching/perl/perl_DBI.html http://structbio.vanderbilt.edu/chazi

[GENERAL] Connect to postgresql database using Perl

Hi, Could anyone please provide me an example to connect to a postgresql database using Perl language and accessing the tables, schemas, and other postgresql objects. Thanks, Dipti

Re: [GENERAL] Connect RDF to PostgreSQL?

On Tue, 2010-02-02 at 08:51 -0500, Aaron wrote: > I am presenting on PostgreSQL tonight and someone e-mailed me with a > question before my talk so I might be able to find him an answer: > > "We are starting a new, large project that uses an ontology based ( > RDF - Resource Description Framework

[GENERAL] Connect RDF to PostgreSQL?

I am presenting on PostgreSQL tonight and someone e-mailed me with a question before my talk so I might be able to find him an answer: "We are starting a new, large project that uses an ontology based ( RDF - Resource Description Framework http://en.wikipedia.org/wiki/Resource_Description_Framewor

Re: [GENERAL] Connect to Postgres problems

Christine Penner wrote: I'm having trouble getting a connection to Postgres to work from outside of my local network. It was working fine at one point. Then I had to change IP addresses and I can't get it to work. This is what I've done. On the computer with Postgres installed I have this in

Re: [GENERAL] Connect to Postgres problems

:49 -0800 > To: raand...@cyber-office.net; pgsql-general@postgresql.org > From: christ...@ingenioussoftware.com > Subject: Re: [GENERAL] Connect to Postgres problems > > I set up port forwarding. I assume that means all IP addresses using > port 5432 will be sent to my lap

Re: [GENERAL] Connect to Postgres problems

I set up port forwarding. I assume that means all IP addresses using port 5432 will be sent to my laptop (that Postgres is running on). I don't remember setting up permissions for a specific IP in the router but it was a while ago so I could be wrong. When I get home I will have another look at

Re: [GENERAL] Connect to Postgres problems

On 02/01/2010 09:16 AM, Christine Penner wrote: When we try to connect we don't get a specific error, just that it can't connect. I'm not sure what logs to look in or on what end. Christine Logging is set up in postgresql.conf per the comments in the file and for more information: http://

Re: [GENERAL] Connect to Postgres problems

Christine Penner wrote: Hi, I'm having trouble getting a connection to Postgres to work from outside of my local network. It was working fine at one point. Then I had to change IP addresses and I can't get it to work. This is what I've done. On the computer with Postgres installed I have thi

Re: [GENERAL] Connect to Postgres problems

> Date: Mon, 1 Feb 2010 09:13:34 -0800 > From: adrian.kla...@gmail.com > To: christ...@ingenioussoftware.com > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Connect to Postgres problems > > On 02/01/2010 09:10 AM, Christine Penner wrote: > > I have re start

Re: [GENERAL] Connect to Postgres problems

When we try to connect we don't get a specific error, just that it can't connect. I'm not sure what logs to look in or on what end. Christine At 09:13 AM 01/02/2010, you wrote: On 02/01/2010 09:10 AM, Christine Penner wrote: I have re started the computer (a few times) since I did all that.

Re: [GENERAL] Connect to Postgres problems

On 02/01/2010 09:10 AM, Christine Penner wrote: I have re started the computer (a few times) since I did all that. Christine What is the error that you are seeing on the client and in the logs? -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@

Re: [GENERAL] Connect to Postgres problems

I have re started the computer (a few times) since I did all that. Christine At 09:08 AM 01/02/2010, you wrote: On 02/01/2010 08:36 AM, Christine Penner wrote: Hi, I'm having trouble getting a connection to Postgres to work from outside of my local network. It was working fine at one point. T

Re: [GENERAL] Connect to Postgres problems

Did you reload postgres configuration after changing pg_hba.conf? On Mon, 2010-02-01 at 08:36 -0800, Christine Penner wrote: > Hi, > > I'm having trouble getting a connection to Postgres to work from > outside of my local network. It was working fine at one point. Then I > had to change IP add

Re: [GENERAL] Connect to Postgres problems

On 02/01/2010 08:36 AM, Christine Penner wrote: Hi, I'm having trouble getting a connection to Postgres to work from outside of my local network. It was working fine at one point. Then I had to change IP addresses and I can't get it to work. This is what I've done. On the computer with Postgres

[GENERAL] Connect to Postgres problems

Hi, I'm having trouble getting a connection to Postgres to work from outside of my local network. It was working fine at one point. Then I had to change IP addresses and I can't get it to work. This is what I've done. On the computer with Postgres installed I have this in the pg_hba.conf file

Re: [GENERAL] Connect without specifying a database?

On Apr 11, 2009, at 6:10 PM, li...@mgreg.com wrote: What do you mean when you say the "catalogs...are database- specific" ? If I'm understanding what you're saying, my whole point is that I don't want to be tied to a database to do any kind of querying about the PG engine itself. Does that

Re: [GENERAL] Connect without specifying a database?

Sam Mason writes: > As others have said; the design of PG is such that it's built to assume > you're always connected to exactly one database. I'd guess this is an > artifact from a long time ago when PG didn't have multiple databases. It's possible that that was true way back in Berkeley prehis

Re: [GENERAL] Connect without specifying a database?

On Apr 11, 2009, at 1:49 PM, Sam Mason wrote: As others have said; the design of PG is such that it's built to assume you're always connected to exactly one database. I'd guess this is an artifact from a long time ago when PG didn't have multiple databases. -- Sam http://samason.me.uk/

Re: [GENERAL] Connect without specifying a database?

On Sat, Apr 11, 2009 at 01:15:44PM -0400, li...@mgreg.com wrote: > > On Apr 11, 2009, at 12:56 PM, Tom Lane wrote: > > > >There is no such edge case. DROP DATABASE has to be issued while > >connected to some database, and it won't let you drop the DB you're > >connected to. > > > >And CREATE DATA

Re: [GENERAL] Connect without specifying a database?

On Apr 11, 2009, at 10:15 AM, li...@mgreg.com wrote: So, how does needing to connect to a database before querying about existing databases make any sense? Well, you have to connect to the database server, no matter what, in order to check on the existence of a database (unless you are doin

Re: [GENERAL] Connect without specifying a database?

On Saturday 11 April 2009 10:15:44 am li...@mgreg.com wrote: > On Apr 11, 2009, at 12:56 PM, Tom Lane wrote: > > There is no such edge case. DROP DATABASE has to be issued while > > connected to some database, and it won't let you drop the DB you're > > connected to. > > > > And CREATE DATABASE ha

Re: [GENERAL] Connect without specifying a database?

On Apr 11, 2009, at 12:56 PM, Tom Lane wrote: There is no such edge case. DROP DATABASE has to be issued while connected to some database, and it won't let you drop the DB you're connected to. And CREATE DATABASE has to be issued while connected to some database, so createdb still has to have

Re: [GENERAL] Connect without specifying a database?

[ forgot to respond to this bit... ] "li...@mgreg.com" writes: > What if you hit that edge case where there are in fact no databases? There is no such edge case. DROP DATABASE has to be issued while connected to some database, and it won't let you drop the DB you're connected to. > I suppose y

Re: [GENERAL] Connect without specifying a database?

li...@mgreg.com wrote: I'm sorry, I'm confused by your reply. I may have said "table" when I meant "database". I believe it absolutely *does* make sense to connect without specifying a database first. What if you hit that edge case where there are in fact no databases? I suppose you could

Re: [GENERAL] Connect without specifying a database?

"li...@mgreg.com" writes: > What do you mean when you say the "catalogs...are database- > specific" ? If I'm understanding what you're saying, my whole point > is that I don't want to be tied to a database to do any kind of > querying about the PG engine itself. Does that make sense? No, i

Re: [GENERAL] Connect without specifying a database?

On Saturday 11 April 2009 9:10:33 am li...@mgreg.com wrote: > On Apr 11, 2009, at 11:56 AM, Tom Lane wrote: > > There are, although we don't spell the commands like that. This is > > not > > relevant to the question of whether it makes sense to connect without > > being connected to a specific dat

Re: [GENERAL] Connect without specifying a database?

On Apr 11, 2009, at 11:56 AM, Tom Lane wrote: There are, although we don't spell the commands like that. This is not relevant to the question of whether it makes sense to connect without being connected to a specific database. It doesn't, because the catalogs that you have to inspect to fi

Re: [GENERAL] Connect without specifying a database?

On Apr 11, 2009, at 10:49 AM, li...@mgreg.com wrote: On Apr 11, 2009, at 11:39 AM, Raymond O'Donnell wrote: The answer is still "no". :-) The usual thing it to connect to the "postgres" database (or to "template1" in older versions of PG), and then you can issue queries to see what's the

Re: [GENERAL] Connect without specifying a database?

On Sat, Apr 11, 2009 at 11:49:25AM -0400, li...@mgreg.com wrote: > I was > hoping there were some higher level management items like "show > databases", and "show tables", etc in Postgres as well. The standard way would be to use the "information_schema", it's in the SQL standard and supported

Re: [GENERAL] Connect without specifying a database?

"li...@mgreg.com" writes: > Hrm...Ok, well, for the record, I'm moving some systems from MySQL to > Postgres and am in the process of getting familiar with it. I was > hoping there were some higher level management items like "show > databases", and "show tables", etc in Postgres as well.

Re: [GENERAL] Connect without specifying a database?

On Apr 11, 2009, at 11:39 AM, Raymond O'Donnell wrote: The answer is still "no". :-) The usual thing it to connect to the "postgres" database (or to "template1" in older versions of PG), and then you can issue queries to see what's there. You're pretty much guaranteed that one of those data

Re: [GENERAL] Connect without specifying a database?

On 11/04/2009 16:30, li...@mgreg.com wrote: > Quick question: Does PGSQL provide a mechanism by which to connect to > the server without specifying a database? I saw a thread back in 2005 > that said "no" > (http://archives.postgresql.org//pgsql-interfaces/2005-02/msg00031.php), > but I was curi

Re: [GENERAL] Connect without specifying a database?

On Sat, Apr 11, 2009 at 11:30:00AM -0400, li...@mgreg.com wrote: > Quick question: Does PGSQL provide a mechanism by which to connect to > the server without specifying a database? I saw a thread back in 2005 > that said "no" > (http://archives.postgresql.org//pgsql-interfaces/2005-02/msg000

[GENERAL] Connect without specifying a database?

Hi All, Quick question: Does PGSQL provide a mechanism by which to connect to the server without specifying a database? I saw a thread back in 2005 that said "no" (http://archives.postgresql.org//pgsql-interfaces/2005-02/msg00031.php ), but I was curious as to whether that's changed. Basi

Re: [GENERAL] Connect to server PG from laptop java app

On 2009-04-05, Johan Nel wrote: > Jennifer, > > Jennifer Trey wrote: >> Hi, I am trying to create my DB schema on the server through my >> development laptop. >> >> I have installed Web Server 2008 and PostgreSQL. They are both running. >> For some reason its not working. Do I need to open som

Re: [GENERAL] Connect to server PG from laptop java app

Also, I don't know if this applies to windows systems, but on linux systems you have to also modify postgresql.conf On my system, it is in the same directory as pg_hba.conf looks like this: #-- # CONNECTIONS AND AUTHENTIC

Re: [GENERAL] Connect to server PG from laptop java app

Jennifer, Jennifer Trey wrote: Hi, I am trying to create my DB schema on the server through my development laptop. I have installed Web Server 2008 and PostgreSQL. They are both running. For some reason its not working. Do I need to open some firewall ports? PostgreSQL runs on 5432. ( I thin

Re: [GENERAL] Connect to server PG from laptop java app

On 05/04/2009 19:52, Jennifer Trey wrote: > no pg_hba entry for host 85.235 user postgres, database xxx .. ssl off Ah... you need to edit pg_hba.conf and add an entry for the client to allow it access. The documentation in the file itself is pretty good, and there's more here: http://www.p

Re: [GENERAL] Connect to server PG from laptop java app

On Sunday 05 April 2009 11:28:09 am Jennifer Trey wrote: > Hi, I am trying to create my DB schema on the server through my development > laptop. > I have installed Web Server 2008 and PostgreSQL. They are both running. For > some reason its not working. Do I need to open some firewall ports? > Post

Re: [GENERAL] Connect to server PG from laptop java app

On 05/04/2009 19:52, Jennifer Trey wrote: > no pg_hba entry for host 85.235 user postgres, database xxx .. ssl off > ... I meant to add too that pg_hba.comf is found in the top level of your PostgreSQL data directory. Ray. -- Ra

Re: [GENERAL] Connect to server PG from laptop java app

no pg_hba entry for host 85.235 user postgres, database xxx .. ssl off ... ?? I guess that means that I need to set up pg then.. how is the question now :) / Jen On Sun, Apr 5, 2009 at 8:35 PM, Raymond O'Donnell wrote: > On 05/04/2009 19:28, Jennifer Trey wrote: > > Hi, I am trying to crea

Re: [GENERAL] Connect to server PG from laptop java app

On Apr 5, 2009, at 1:28 PM, Jennifer Trey wrote: Hi, I am trying to create my DB schema on the server through my development laptop. I have installed Web Server 2008 and PostgreSQL. They are both running. For some reason its not working. Define : "it's" Do I need to open some firewall

[GENERAL] Connect to server PG from laptop java app

Hi, I am trying to create my DB schema on the server through my development laptop. I have installed Web Server 2008 and PostgreSQL. They are both running. For some reason its not working. Do I need to open some firewall ports? PostgreSQL runs on 5432. ( I think I did that though). Do I need to con

Re: [GENERAL] "connect by"

On Jun 9, 4:54 pm, [EMAIL PROTECTED] ("Roberts, Jon") wrote: > I need a high performing version of Oracle's connect by functionality in > PostgreSQL.  I saw some dispute about attempts to add this in the > archives and a reference to an ANSI alternative "with" statement.  Is > either of these funct

Re: [GENERAL] "connect by"

Roberts, Jon <[EMAIL PROTECTED]> schrieb: > I need a high performing version of Oracle's connect by functionality in > PostgreSQL. I saw some dispute about attempts to add this in the > archives and a reference to an ANSI alternative "with" statement. Is > either of these functions available yet

[GENERAL] "connect by"

I need a high performing version of Oracle's connect by functionality in PostgreSQL. I saw some dispute about attempts to add this in the archives and a reference to an ANSI alternative "with" statement. Is either of these functions available yet? I'm using 8.3. Jon -- Sent via pgsql-general

Re: [GENERAL] Connect to postgres from a dynamic IP

Jorge Godoy wrote: Em Monday 03 March 2008 13:17:03 você escreveu: My understanding is no password is sent in the clear with md5 per: http://www.postgresql.org/docs/8.3/interactive/auth-methods.html#AUTH-PASSW ORD But the MD5 hash is. This page states that the password can't be directly sni

Re: [GENERAL] Connect to postgres from a dynamic IP

Em Monday 03 March 2008 13:17:03 você escreveu: > > My understanding is no password is sent in the clear with md5 per: > > http://www.postgresql.org/docs/8.3/interactive/auth-methods.html#AUTH-PASSW >ORD But the MD5 hash is. This page states that the password can't be directly sniffed, but one c

Re: [GENERAL] Connect to postgres from a dynamic IP

Andrei Kovalevski <[EMAIL PROTECTED]> writes: > Does anybody ever measured performance slowdown for SSL connections? It's pretty significant percentage-wise on a local-loopback connection, but for a connection over the open Internet I doubt it'd be an issue. Unless your data is completely not pri

Re: [GENERAL] Connect to postgres from a dynamic IP

Hello, Jorge Godoy wrote: Em Monday 03 March 2008 08:08:36 Raymond O'Donnell escreveu: On 03/03/2008 11:01, dfx wrote: The question il: Is there a method to avoid to insert the addesses of the clients in the pg_hba.conf and to allow connections from internet with security assured only

Re: [GENERAL] Connect to postgres from a dynamic IP

But make it "hostssl" instead of "host", to require some cryptography in the channel used, specially to authenticate the connection. Opening your access to everyone without crypto sounds like something you don't want to do. Specially if users can change their own passwords... My underst

Re: [GENERAL] Connect to postgres from a dynamic IP

Collin wrote: But make it "hostssl" instead of "host", to require some cryptography in the channel used, specially to authenticate the connection. Opening your access to everyone without crypto sounds like something you don't want to do. Specially if users can change their own passwords

Re: [GENERAL] Connect to postgres from a dynamic IP

Jorge Godoy wrote: Em Monday 03 March 2008 08:08:36 Raymond O'Donnell escreveu: On 03/03/2008 11:01, dfx wrote: The question il: Is there a method to avoid to insert the addesses of the clients in the pg_hba.conf and to allow connections from internet with security assured only by usern

Re: [GENERAL] Connect to postgres from a dynamic IP

Em Monday 03 March 2008 08:08:36 Raymond O'Donnell escreveu: > On 03/03/2008 11:01, dfx wrote: > > The question il: Is there a method to avoid to insert the addesses of > > the clients in the pg_hba.conf and to allow connections from internet > > with security assured only by username and password?

Re: [GENERAL] Connect to postgres from a dynamic IP

On 03/03/2008 11:01, dfx wrote: The question il: Is there a method to avoid to insert the addesses of the clients in the pg_hba.conf and to allow connections from internet with security assured only by username and password? Yes, that's what people have been explaining: you insert a line somet

Re: [GENERAL] Connect to postgres from a dynamic IP

am Mon, dem 03.03.2008, um 11:59:36 +0100 mailte Magnus Hagander folgendes: > > > How I have to configure pg_hba.conf (and/or eventually my router, where > > > the > > > server is located)? > > > > Set the CIDR to 0.0.0.0/32. > > That should be 0.0.0.0/0, I beleive. > > //Magnus Magnus, right

Re: [GENERAL] Connect to postgres from a dynamic IP

On Mon, Mar 03, 2008 at 11:33:17AM +0100, A. Kretschmer wrote: > am Mon, dem 03.03.2008, um 11:01:17 +0100 mailte dfx folgendes: > > Dear Sirs, > > > > it is possible to connect to PostgreSQL server from a client with a dynamic > > IP (or from an unknown IP)? > > Of course, yes. > > > > > > H

Re: [GENERAL] Connect to postgres from a dynamic IP

I apologize for my confuse exposition. My server has a static, well known IP. The problem is that I don't know the IP of my customers (client side) and then I cannot insert those addresses in pg_hba.conf file. The question il: Is there a method to avoid to insert the addesses of the clients in t

Re: [GENERAL] Connect to postgres from a dynamic IP

am Mon, dem 03.03.2008, um 11:01:17 +0100 mailte dfx folgendes: > Dear Sirs, > > it is possible to connect to PostgreSQL server from a client with a dynamic > IP (or from an unknown IP)? Of course, yes. > > How I have to configure pg_hba.conf (and/or eventually my router, where the > server i

Re: [GENERAL] Connect to postgres from a dynamic IP

Em Monday 03 March 2008 07:01:17 dfx escreveu: > it is possible to connect to PostgreSQL server from a client with a dynamic > IP (or from an unknown IP)? > > How I have to configure pg_hba.conf (and/or eventually my router, where the > server is located)? You'll have to make PostgreSQL accept co

Re: [GENERAL] Connect to postgres from a dynamic IP

yes, it is possible if you use a service like dyndns: http://www.dyndns.com/ to "convert" your dynamic ip. If you use this service you connect your dynamic ip to a hostname, which is dynamically updated by this service. after that you can change your windows hosts file to add the hostname you have

[GENERAL] Connect to postgres from a dynamic IP

Dear Sirs, it is possible to connect to PostgreSQL server from a client with a dynamic IP (or from an unknown IP)? How I have to configure pg_hba.conf (and/or eventually my router, where the server is located)? I have no possibility to change the settings of clients (my customers) Thank you. D

Re: [GENERAL] Connect to SQL Server via ODBC from Postgresql

Merlin Moncure wrote: On Jan 4, 2008 11:51 AM, Afewtips.com <[EMAIL PROTECTED]> wrote: I do read mentions about dblink connections, but how to install it looks unclear and complicated. small clarification here. dblink is for connecting two postgresql databases together. It is, IMO, neither

Re: [GENERAL] Connect to SQL Server via ODBC from Postgresql

On Jan 4, 2008 11:51 AM, Afewtips.com <[EMAIL PROTECTED]> wrote: > > I do read mentions about dblink connections, but how to install it > > looks unclear and complicated. > > small clarification here. dblink is for connecting two postgresql databases together. It is, IMO, neither unclear nor com

Re: [GENERAL] Connect to SQL Server via ODBC from Postgresql

Ow Mun Heng wrote: On Tue, 2008-01-08 at 23:16 -0800, Joshua D. Drake wrote: Ow Mun Heng wrote: On Wed, 2008-01-09 at 08:41 +0200, Sim Zacks wrote: Another way of doing this, without dblink, is using an unsecured language (plpython, for example) is to connect to the sql server using odbc and t

Re: [GENERAL] Connect to SQL Server via ODBC from Postgresql

On Tue, 2008-01-08 at 23:16 -0800, Joshua D. Drake wrote: > Ow Mun Heng wrote: > > On Wed, 2008-01-09 at 08:41 +0200, Sim Zacks wrote: > >> Another way of doing this, without dblink, is using an unsecured language > >> (plpython, for example) is to connect to the sql server using odbc and > >> t

Re: [GENERAL] Connect to SQL Server via ODBC from Postgresql

Ow Mun Heng wrote: On Wed, 2008-01-09 at 08:41 +0200, Sim Zacks wrote: Another way of doing this, without dblink, is using an unsecured language (plpython, for example) is to connect to the sql server using odbc and then putting the data into your postgresql. I use perl DBI to connect to both

Re: [GENERAL] Connect to SQL Server via ODBC from Postgresql

On Wed, 2008-01-09 at 08:41 +0200, Sim Zacks wrote: > Another way of doing this, without dblink, is using an unsecured language > (plpython, for example) is to connect to the sql server using odbc and then > putting the data into your postgresql. I use perl DBI to connect to both PG and MSSQL.

Re: [GENERAL] Connect to SQL Server via ODBC from Postgresql

Another way of doing this, without dblink, is using an unsecured language (plpython, for example) is to connect to the sql server using odbc and then putting the data into your postgresql. Sim Afewtips.com wrote: On Jan 4, 10:08 am, "Afewtips.com" <[EMAIL PROTECTED]> wrote: Hi, I am new to t

Re: [GENERAL] Connect to SQL Server via ODBC from Postgresql

On Jan 4, 10:08 am, "Afewtips.com" <[EMAIL PROTECTED]> wrote: > Hi, > I am new to this product and don't quite know what can and cannot be > done. > > I need to submit queries to a SQL Server database and create a table > in Postgresql with the results from SQL Server. > > Normally I would do this

[GENERAL] Connect to SQL Server via ODBC from Postgresql

Hi, I am new to this product and don't quite know what can and cannot be done. I need to submit queries to a SQL Server database and create a table in Postgresql with the results from SQL Server. Normally I would do this with an ODBC driver into SQL Server, but I don't see any references to doing

Re: [GENERAL] connect by service name in psql

"Tom Lane" wrote in message news:[EMAIL PROTECTED]: > "Stuart" <[EMAIL PROTECTED]> writes: > >> I can't find an option in psql to connect to a database > >> by "service" name? Should there be one? > > In 8.3 libpq will have code that interprets what's usually the database > name parameter as a "

Re: [GENERAL] connect by service name in psql

"Stuart" <[EMAIL PROTECTED]> writes: >> I can't find an option in psql to connect to a database >> by "service" name? Should there be one? In 8.3 libpq will have code that interprets what's usually the database name parameter as a "conninfo" string if there's an "=" in it, which means you can ge

Re: [GENERAL] connect by service name in psql

"Stuart" wrote in message news:[EMAIL PROTECTED]: > I can't find an option in psql to connect to a database > by "service" name? Should there be one? Sorry for folowing up my own post but since I got asked in email, and since I wrote code to do essentially the same thing before noticing it in

[GENERAL] connect by service name in psql

I can't find an option in psql to connect to a database by "service" name? Should there be one? ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [GENERAL] CONNECT privilege

"Joris Dobbelsteen" <[EMAIL PROTECTED]> writes: > It seems that the CONNECT privilege cannot be assigned or is not > recognized by postgresql 8.1. That was added in 8.2, as even minimal perusal of the documentation would have shown you. regards, tom lane -

Re: [GENERAL] CONNECT privilege

Joris Dobbelsteen wrote: When using pgAdmin-III it does not display the granted CONNECT priviledge. Also when doing GRANT CONNECT FOR DATABASE TO it succeeds, but I fail to observe its effects: i.e. users are not allowed to a database. Have you modified pg_hba.conf to allow the new use

[GENERAL] CONNECT privilege

I've set up a little test to find out how much permissions users have in PostGreSQL. It seems that the CONNECT privilege cannot be assigned or is not recognized by postgresql 8.1. When using pgAdmin-III it does not display the granted CONNECT priviledge. Also when doing GRANT CONNECT FOR DATABASE

Re: [GENERAL] Connect to a database in a .sql file

Assad Jarrahian wrote: Got it. I will be more careful with words. Thanks tom for getting 8.1! one more question. Where does the directory lie for psql (so I can put a .sql file in there and run it) for windows? I'm not familiar with the Windows version, but the psql.exe file should be with al

Re: [GENERAL] Connect to a database in a .sql file

Assad Jarrahian wrote: I converted your HTML message to plain text for you. > Where does the directory lie for psql (so I can put a .sql file in > there and run it) for windows? thanks. It's in the bin directory underneath wherever you install PostgreSQL. But you don't need to put your .sql scri

Re: [GENERAL] Connect to a database in a .sql file

On Tue, 2005-11-08 at 07:31, Assad Jarrahian wrote: > Hi, > Lets say the script is called myDBSetup.sql > > And the script contains: > > //CREATE DATABASE section > //CREATE USERS SECTION > //COnnect to db > //CREATE TABLES, FUNCTIONS etc. > > this script will be called from psql. The user w

Re: [GENERAL] Connect to a database in a .sql file

Got it. I will be more careful with words. Thanks tom for getting 8.1! one more question. Where does the directory lie for psql (so I can put a .sql file in there and run it) for windows? thanks. -assad On 11/8/05, Richard Huxton wrote: Assad Jarrahian wrote:> Sorry, I am a li

Re: [GENERAL] Connect to a database in a .sql file

Assad Jarrahian wrote: Sorry, I am a linux/OS X person. Was working on PGADMIN in windows and thought their query tool was the same as psql. Nope - psql is psql, pgadmin is pgadmin. All the backslash commands are psql-only rather than being part of the backend. Of course, pgadmin can duplicat

Re: [GENERAL] Connect to a database in a .sql file

Sorry, I am a linux/OS X person. Was working on PGADMIN in windows and thought their query tool was the same as psql. Just ran the script in psql on my linux box and it worked. My apologies.    Tom, I am not leaping to silly conclusions. Calm down please. We are all trying to learn from people wit

Re: [GENERAL] Connect to a database in a .sql file

Assad Jarrahian wrote: \c does not work in .sql script run in psql. That sounds unlikely. What sort of error message are you getting? -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please s

  1   2   >