[GENERAL] Re: MS Excel to PostgreSQL?

[Craig Orsinger]

Rudolf Potucek wrote:
> 
> Hi Everyone!
> 
> I am trying to make MS Excel/MS query talk to a postgreSQL database. Is
> there a way to configure the linux or the MS side so they can talk to
> each other?

I've never used Excel, but it's possible to use ODBC to query
a PostgreSQL database from a Windows system. You need to install the
PostgreSQL ODBC drivers, of course, and set up a connection using
the ODBC control panel. I've done this to allow MS Access to query a
PGSQL database on a Unix system.

If you are interested in trying this, the most current version
of the PGSQL ODBC drivers are located at:

ftp://ftp.postgresql.org/pub/odbc/versions/v06-50-/

IIRC, the file "postdrv.exe" is what you're looking for.

For more information, check the PostgreSQL FAQ at:

http://www.postgresql.org/users-lounge/docs/faq.html

[GENERAL] Re: perl vs php for postgresql

[Craig Orsinger]

In article , "John"
<[EMAIL PROTECTED]> wrote:

> It seems that I having problems locating the DBM:Pg module. I even
> followed the instructions on compiling postgresql to support it.  My
> perl scripts don't seem to know about a Pg module and I have not had any
> luck finding answers. Is is easier to use php with postgresql? Will I
> have the same kinds of problems?  Thanks for any advice.

I can't comment on the relative ease, but PHP is easy to use, at 
least for small projects like mine. I don't mean to start a flame war
here, but Perl's syntax alwasy seemed a little obscure to me. I'm used
to C and C-inspired shells. Not knowing anything about PHP, it took 
me about an hour to build a page that would display an HTML table
from select, with color-coded rows. Not too bad for an occasional
programmer.

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

[GENERAL] NOTIFY/LISTEN Using Embedded SQL (ecpg)

[Craig Orsinger]

[cross posted from comp.databases.postgresql.general]

I seem to have painted myself into a corner, technologically speaking.
I am implementing a database using embedded SQL, and PostgreSQL
6.5.3 as the backend. The problem is that I would like to use the NOTIFY
feature, but the only way I've found of doing this from within a C
program is to use the 'PQnotifies()' function, which requires a PGconn
connection its first parameter. ESQL doesn't provide this connection
information as far as I can tell.

 So, it appears that I can set up my program to LISTEN or
UNLISTEN using embedded SQL, but I can't get a notification when
it's sent. Or so I think. _Is_ there a way to get the libpq connection info
from the ESQL CONNECT call?

Does anyone have a suggestion (other than completely rewriting
my application in libpq calls)? Pointers to any examples of how
this is done would be especially helpful, but any hints would be
appreciated.

Here's an example that may help illustrate my problem:

int main()
{
   PGconn *conn = NULL;

EXEC SQL CONNECT database ;

 EXEC SQL LISTEN foo_changed ;

 for( ; /* EVER */ ; )
 {
  if( PQnotifies(conn) ) /* conn is still NULL */
 printf("Something happened\n" ) ;

   .
 }
}

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[GENERAL] Re: Where can I get free ODBC drivers for postgres?

[Craig Orsinger]

In article , "SUDDN"
<[EMAIL PROTECTED]> wrote:
> Are there any free ODBC drivers avaliable?  If so where can I find them?
> 
> Thanks

For Windows NT, there are free PostgreSQL ODBC drivers available at:

ftp://ftp.postgresql.org/pub/odbc/index.html

Use that URL to bring up the web page. Chop off the "index.html" part to get to
the FTP site.