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)

1
vote
1answer
11 views

SQL Query: Group Time into timeslices then group by loginname then count distinct loginnames per timeslice

I have a huge table containing starting times of the operation (starttime) + the user who started it (loginname) + a lot of date which is uninportant for the query i need. From that i want to group ...
0
votes
0answers
10 views

postgresql to mssql query conversion

can any one help me to convert the following query into mssql which is working on postgresql now query is to take the updated datetime of the report in the asc order of the date select count(*) ...
0
votes
2answers
12 views

I want to do an autocomplete with Ruby and Sequel

I am using Sequel with prostgres and Sinatra. I want to do an autocomplete search. I’ve verified my jQuery which sends a GET works fine. The Ruby code is: get '/search' do search = params[:search] ...
-2
votes
1answer
22 views

How to integrate Oracle and Postgres? [closed]

I have two servers, one uses oracle and the other postgres. Now we need some data from oracle db to postgres db. How to integrate both databases? I planned to get data from oracle and post it to ...
0
votes
0answers
11 views

Is there a way to use Django introspection with schemas

I have a database with four schemas. I've used PostGres' 'SET search_path' command to look at them all so that: psql -d pngris -c "SHOW search_path" (my database being 'pngris') results in : ...
1
vote
1answer
13 views

PGSQL Error Code 42703 column does not exist

I have a database in postgreSQL. I want to read some data from there. But i get an error (column anganridref does not exist) when i execute my command. Here is my NpgsqlCommand cmd.CommandText = ...
0
votes
0answers
29 views

Multiple nested update/insert statement in postgres

I have the problem, that I have to do an insert into on table of my database and a update another table with the id, the insert provided me with. I tried this: UPDATE events SET mail_key = ( INSERT ...
0
votes
1answer
15 views

Locking postgresql table

Is it possible to lock a table for a specified time in PostgreSQL database by running psql commands via shell script or sql file? If we run the LOCK TABLE command, when the script exits the lock ...
0
votes
0answers
20 views

Postgresql Update command is too slow

I have the following postgresql table: CREATE TABLE "initialTable" ( "paramIDFKey" integer, "featAIDFKey" integer, "featBIDFKey" integer, "featAPresent" boolean, "featBPresent" ...
0
votes
2answers
22 views

how to get timestamp from user input(FORM) to its actual data?

let say I have a form: <form ... > <input type="text" name="date" /> //input here is 2013-06-14 09:00:00 </form> I assigned it to let say: $log = new record(); ...
0
votes
1answer
17 views

PG syntax error

I've been trying to convert the fedena project built on ruby on rails for my school from mySQL to postgreSQL for heroku deployment and ran into the following error: Showing ...
0
votes
0answers
18 views

How to recompile the PHP with --with-pgsql [migrated]

I have installed the postgresql, php and apache to Amazon Linux AMI. Now I want to use the phpPgAdmin, it prompts "Your PHP installation does not support PostgreSQL. You need to recompile PHP using ...
0
votes
1answer
10 views

Displaying binary images on JSP page

So here is the problem. I have images stored in PostgreSQL in bytea (byte array) type. Also I have a home JSP page, which has to display all photos from db. Please, point me to the solution or some ...
0
votes
1answer
25 views

query works on postgresql but not on php

Let's say, I I have this query in my postgresql. SELECT * FROM logs WHERE user_id = 8328 AND punchin::date = '2013-06-11'; it returns successful. But when I implent it in PHP: $sql = "SELECT * ...
-1
votes
0answers
29 views

How to insert encryption japanese data to postgres database with C++ [closed]

I am studying C++. I want to insert encryption data into a Postgres or other DB. I don't know how to do this, and I cannot find any other source on the internet. I want to insert this data: ...

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