database postgresql

I have two databases: 1) accounts-management 2) games-management I want to make reports, which use data from both databases and i want to have third…

I have the following table defined, which uses PostGIS geography. CREATE TABLE test_geog ( id SERIAL PRIMARY KEY, boundary GEOGRAPHY(Polygon) ); I…

I have the following JDBC code. Note that I am attempting to use PostGIS geography: PreparedStatement stmt = db.prepareStatement("INSERT INTO " +…

This query work when I try it in SQLite: Transaction.where(:paid => true).select("created_at, SUM(amount)…

For use in OLTP richclient apps (C# or Delphi), which do you prefer and why? Any advice, warning, hint, features and performances comparison would…

I'm working on small tool for gathering information about our postgres database and I have been looking at using the postgres Stats Collecter . It…

I have two postgres database in different linux server, the thing is that I want to synchronize all the data which are inserted , updated, deleted…

I know I can setup a FK constraint to make sure Table1.ColA exists in Table2.Key, however what if I want to do the reverse? I want to ensure…

I'm am having some trouble with a PostgreSQL query What I want is a list of "Campaigns", ordered by distance, and within a minimum distance from a…

Hallo, I am writing a database application that does alot of inserts and updates with fake serialisable isolation level ( snapshot isolation ). To…

I am trying to build a database for my company and my programmer does not know how to have a number which fills itself in like in Access 2003. In…

I need to create a history table for particular resource and am trying to decide how to design it. My current thought was to create a separate table…

I'm looking into implementing object-versioning with the added twist of needing to have both live and draft objects, and could use the insights from…

`postgresql_connection': No database specified. Missing argument: database. (ArgumentError) I installed postgresql using Homebrew and am able to…

I am collecting lots of data from lots of machines. These machines cannot run PostgreSQL and the cannot connect to a PostgreSQL database. At the…

I m new to postgresql and database part. I want to check function exit or not in postgresql using trigger before insert statement. any body know how…

I have a little question. I am looking for a mode to connect to all types of databases using php and I don't find anything usefull. For example I am…

If we have the same database schema in a database on Postgresql and on MsSql Server (table, primary keys, indexes and triggers are the same) what…

I have an issue where I have one column in a database that might be anything from 10 to 10,000 bytes in size. Do you know if PostgreSQL supports…

I'm doing web application for many users. Application will has many modules - register, search, question-answer, forum and blog. I'm going to…