I use postgress to manage a small amount of data (ca. 25MB), but often
changed.
This is a mirror of several tables taken form four different databases.
All data are updated once per hour (or sometimes on demand)

Due to recent action by Google concerning the comp.databases.postgresql.*
hierarchy, we are going to make some changes that should satisfy just
about everyone ... over the next 24hrs or so, traffic *to*
comp.databases.postgresql.* from the mailing lists will cease and be

I am wanting to setup/run PostgreSQL on my server (a SuSE Linux 9.2 distro)
but I'm not quite sure which way to go.
I have a few books on PostgreSQL but they don't seem to match the way SuSE
has installed it. The books explain how to install/make/etc. and then how

I am trying to restore a dump from 7.4.1 to 8.0.
I am using the pg_dump in 8.0 to dump the database. I am getting the
following error message.
I looked up the pg_database table in 8.0 and there is not column named

hi, could someone please tell me how do I get a query to show the (*) fields
in table2 only  when table2.field1 exist in table1.field1
thanks in advance.
jenny

I'm a new user of PostgreSQL.
I want to create a catalogue of books but there are several problems.
Here are the two tables I need:
create table books (

Hi Group,
My Postgres7.3 on Debian runs out of connections every month or so.
I restart and all problems are gone, but clearly something is bad.
(All running apps report broken pipes when it happens)

Is there any way to recover data after a mistaken delete query, using
the binary data files? For example, can I make a database return to the
state it was one day ago?
Thanks in advance,

I just installed postgresql 7.4.5 and pgadmin3 1.0.2 on FreeBSD and noticed
that pgadmin allows the pgsql user to log in while ignoring the password.
You can enter a wrong password or no password and still get into postgresql.
I started the postmaster as a FreeBSD user named pgsql ...

I'm using Postgresql, writing C programs to access the data.  So far
I've done this on my Debian box, using the postgresql-dev package.
Now I'm trying to do the same on a Macintosh using the package from
Marc Liyanage's page

This newsgroup seems dead to me. :-(
What is a better place to discuss Postgresql related stuff?
TIA!
Regards,

I have a one table with this columns:
date, article_name,  quantity
I interesting how can I select from this table to get
article_name, sum(quantity) for all dates in table

I got a file with a lot of numbers that are strings. I'd like to read all
this numbers and convert them to numbers for futher compareation. How can I
convert all this numbers to integer?
regards