Imagine I have built a program based on PostgreSQL. There is a statement
that anyone can use and distribute or modify PostgreSQL software provided
that he includes a document with the license statements. If I include this
license statements and distribute only binaries of the ...

Goodmorning,
I'm quite new to PostgreSQL, started off with version 8.0 some time ago.
Recently I've begun working with stored procedures and now I've come
accross a little problem / issue I can't seem to figure out.

I have a table with about 400,000 records and a btree index (numeric). A
simple SELECT * FROM table WHERE id = ... takes more than a second for
every query and I need to query each record at least once. It helps to
do an UPDATE tabel WHERE id IN (..., ...), but I don't have the ...

I want to calculate the duration of time for a timecard project.  This
is a sample:
totaltime = (endtime1 - starttime1) + (endtime2 - starttime2)
totaltime is numeric, starttime1 & 2, endtime1 & 2 are ISO time values.

   I have 2 databases on PostgreSQL, for instance base1, base2.
I connect to psql: psql -p 3333 base1
how can I access to base2 ?
for instance I wont do instruction:

Given table all_prices:
product_id | company_id | price
-----------+------------+------
1                0          1

does anyone know about a tool (free or commercial) for object and relation
view for postgres?
Thanks for any help.
MK

How does one import data INTO a table.  I am forced to read files (\i)
w/ a ton of insert statements.  I am trying to import approx 800 lines
into the table. However, I must bundle them into a series of files
because of the bug in PGSQL (the buffer overflows).  Interestingly,

I think I have postgress installed on my redhat 7.3 box
~  User=root $ps -ef | grep postgr
postgres  1295     1  0 02:26 ?        00:00:00 /usr/bin/postmaster
postgres  1297  1295  0 02:26 ?        00:00:00 postgres: stats buffer

I'm a developer currently wondering which DB choose for my next project.
I looked on the net found ofcourse Oracle but also came up with
PostgreSQL. I heard quite few things about it, all good so I'm wondering
 how really it is.

Hello :)
I'm working on an internet application with MS.Net client program, which is
supposed to communicate with database through PHP or ASP-based webservice.
The database is to hold up to 20-30 mln records in less then hundred

Hope this is the right group to post this Q! Don't shoot please.
Ive got my postmaster service running on my Mandrake 9.1. I'm able to run
pgsql, and to 'show all' on a db I've created. Done this under a terminal.
However, when I try to run PGADMIN3, system gives me: "No pg_hba.conf ...

Anybody knows how to get table names from SageLine50 by ODBC.
select * from system_schema.tables is not working for this.
anybody has ever come across this?
thank you