Tagged Questions

PostgreSQL is an open-source, object-relational database management system (ORDBMS) available for many platforms including Linux, UNIX, MS Windows and Mac OS X. Please mention your PostgreSQL version when asking questions.

learn more… | top users | synonyms (3)

0
votes
1answer
12 views

PHP script not inserting into pg database

I am writing a basic PHP registration script with the following database: DROP TABLE IF EXISTS authentication; CREATE TABLE authentication ( userID SERIAL UNIQUE REFERENCES users(userID), ...
0
votes
0answers
7 views

psql: FATAL: database “<user>” does not exist

I'm using the PostgreSql app for mac (http://postgresapp.com/). I've used it in the past on other machines but it's giving me some trouble when installing on my macbook. I've installed the application ...
0
votes
1answer
10 views

Is there a way to index in postgres for fast substring searches

I have a database and want to be able to look up in a table a search that's something like: select * from table where column like "abc%def%ghi" or select * from table where column like "%def%ghi" Is ...
0
votes
0answers
8 views

Timezone with Postgres on Windows

I am storing a time field in a timestamp without timezone column. The data is stored in UTC time. When I call the data back on heroku I get somehting like 2013-07-13T18:06:41.000Z which is what I ...
0
votes
1answer
13 views

PostgreSQL: Full text search multitenant site, plus only parts of site

I'm developing a multitenant web application, and I want to add full text search, so that people will be able to: 1) search only the site they are currently visiting (but not all sites), and 2) ...
0
votes
1answer
12 views

Postgres: unique on array and varchar column

I would like to ask if it is possible to set UNIQUE on array column - I need to check array items if are uniqued. Secondly, I wish to have also second column to be included in this. To imagine what ...
2
votes
1answer
30 views

SQL — computing end dates from a given start date with arbitrary breaks

I have a table of 'semesters' of variable lengths with variable breaks in between them with a constraint such that a 'start_date' is always greater than the previous 'end_date': id start_date ...
1
vote
2answers
30 views

I just want to make A simple loop in PostgreSQL

In the PostGIS SQL Editor, I just want to make a loop to make this function work For Loopid = 0 to 1000, then execute the following statments: UPDATE public.globaldtm SET "UTM" = loopid WHERE rid ...
1
vote
1answer
11 views

Expand array type column to data from referencing table (Metadata query)

I'm constructing queries using Postgres' metadata tables (system catalogs) to fetch some information I need. The pg_constraint catalog has a column called conkey which is of type int2[] and it ...
1
vote
0answers
13 views

Best Practices - RoR 4 Heroku - Cron to fill database each hour from external API

I have to call externals API to fill my database, hosted on Heroku each hours. For this purpose, I've a ruby script that get all the data from externals API and output on the stdout. Now, I would ...
7
votes
2answers
84 views

Problematic nameless table in Postgresql

I actually don't know how I've done it : but I got a nameless table into my postgres DB. Needless to say that such a table is problematic, it doesn't get erased, neither could you change it in any ...
0
votes
1answer
18 views

How do I translate PostgreSQL OID using python

I am having bit of trouble with the psycopg2 Python module. I wrote a small code to extract some information from PostgreSQL table using psycopg2 module. I want to know the data type for each columns ...
0
votes
0answers
13 views

Save changes to database vaadin

I have an application which has a table and when you click on an item in the table it fills in a group of textfields with its data (FieldGroup), and then you have the option of saving the changes I ...
0
votes
0answers
17 views

How to do incremental/differential backup every hour in Postgres 9.1?

(I originally asked this on dba.stackexchange.com, but didn't get much of a response. I will delete it there once the bounty is over). Trying to do an hourly hot incremental backup of a single ...
0
votes
0answers
11 views

Informix to Postgres, continuous data replication algorithm

The master server is Informix, version varies from 9.40 to the latest, database is unlogged by design that can't be changed. Slave server is the latest PostgreSQL. Master and slave are separate ...

1 2 3 4 5 … 1209
15 30 50 per page