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
21 views

Download several excel files with one click

I have several php files which contain different queries to a postgresql database. There about sixteen of these files. Each of these files returns a different set of data based on the query within the ...
4
votes
2answers
39 views

Counting number of medals in weekly tournaments

I have a table holding weekly scores of players: # select * from pref_money limit 5; id | money | yw ----------------+-------+--------- OK32378280203 | -27 | 2010-44 ...
-1
votes
0answers
12 views

Symfony and PosgreSQL: [PDOException] could not find driver

i get the error: [PDOException] could not find driver when i try to running this command: php app/console doctrine:schema:update --force i'm using wamp server and posgresql, php_pdo_pgsql and ...
1
vote
0answers
8 views

What is the purpose of the input output functions in Postgresql 9.2 user defined types?

I have been implementing user defined types in Postgresql 9.2 and got confused. In the PostgreSQL 9.2 documentation, there is a section (35.11) on user defined types. In the third paragraph of that ...
0
votes
2answers
15 views

single quotes appear arround value after running copy in postgres 9.2

I am new to postgres and I play around with data loading. Here is the table definition from postgres 9.2 spec: CREATE TABLE weather ( city varchar(80), temp_lo int, -- low temperature ...
-7
votes
0answers
38 views

connect two tables with ruby on rails [closed]

Hi I am new to ruby on rails. I want to know how to connect two tables in the database I want to take an id from the first table(contacts) and update the second table(contacts_social) with a value. ...
0
votes
1answer
16 views

Error installing Postgres module in Node.js and 2 other node.js questions

I am having trouble installing the Postgres database module for Node.js, every time I run the command "npm install pg" I get the following error: C:>npm install pg npm http GET ...
6
votes
4answers
75 views

Left join on column isn't in the relationship between two tables

I have 2 tables: CREATE TABLE plans (id int, benefit varchar(5), clip_state int); INSERT INTO plans (id, benefit, clip_state) VALUES (1, 'A', 1), (2, 'A', 0), (3, 'B', 0), ...
1
vote
2answers
29 views

How to md5 all columns regardless of type

I would like to create a sql query (or plpgsql) that will md5() all given rows regardless of type. However, below, if one is null then the hash is null: UPDATE thetable SET hash = md5(accountid ...
0
votes
1answer
18 views

Remove extra white space from input in cakephp

I have a html form to save projects in cakephp. i want to restrict the user to save same project name. If any body type the same project name for that i applied the 'unique' validation in model but if ...
0
votes
1answer
24 views

rails console say “Table doesn't exist” but it shows up in my schema

I am creating a join table for Equipment and Instructors called EquipmentOwnership. class EquipmentOwnership < ActiveRecord::Base attr_accessible :equipment_id, :instructor_id, :owned ...
-1
votes
0answers
18 views

Which CMS offer robust Postgresql support and allow easy CRUD forms design and reports for users with no programmer skills

I'm looking for a free CMS with an active community for building an intranet over a PostgreSQL database. The main objective is to allow the users to build customs forms and reports to fill and consult ...
1
vote
1answer
19 views

PostgreSQL exceptions with failed inserts

Is there any circumstance where an exception will not be thrown if an insert statement in a stored procedure fails? I'm using catch-all style exception handling in my PostgreSQL stored procedures via ...
0
votes
2answers
30 views

Error displaying image in jsp

I know there are some relevant questions, but none of them covers my subject. So, I have a web application using jsp, java, postgresl and apache tomcat 7.0.27.0 embedded inside NetBeans (as a plugin) ...
0
votes
1answer
30 views

Links to files outside a PostgreSQL database

A stupid newbie question: I want to make a PostgreSQL (9.2.2 with PostGIS 2.0.1; on 32-bit Windows XP) database with rasters saved outside the database (I will need the rasters to be accessed from ...

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