Skip site navigation (1) Skip section navigation (2)

Re: Hello World

From: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
To: "Andreas" <maps(dot)on(at)gmx(dot)net>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Hello World
Date: 2006-11-21 09:45:53
Message-ID: (view raw or whole thread)
Lists: pgsql-jdbc
Andreas wrote:
> Hi,
> first of all I'll have to confess I don't know next to nothing at all 
> about JAVA, yet.
> On the other hand I'm not exactly new to programming nor PostgreSQL either.
> Is there a "Hello World" level sample for jdbc with PG?

I'd suggest to read the Java Tutorial by Sun:

and after you got the basics, move on to the JDBC trail of the tutorial:

> Lets suppose I allready have a running PG with a db db_test that has a 
> few tables among which there is tbl_test in schema s.
> The db-server might be
> User could be "user1" with password "pw1".
> What would be minimally needed to connect to db_test and read the 
> content of tbl_test to the console and logg off from PG.
> I'd prefer a complete sample code that could be dumped through javac.

A sample attached. Save it to a file called, modify the 
server address, database name, table name etc. to suite your needs, and 
compile with "javac". To run, add postgresql.jar to your 
classpath. For example:

java -cp path/to/postgresql.jar JdbcTest

   Heikki Linnakangas

Description: text/x-java (396 bytes)

In response to

pgsql-jdbc by date

Next:From: Heikki LinnakangasDate: 2006-11-21 10:30:13
Subject: Re: exception with a temporary table
Previous:From: Ido M. TamirDate: 2006-11-21 09:35:40
Subject: Re: Hello World

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group