hello. im trying to query between dates for example:
select * from bookings where date between '12/28/2008' and '12/29/2008'
date is a timestamptz datatype.
how do i do this in postgres?
I am creating a SQL Script in PostgreSQL. I need it to check if a function exists in the database and if so, I need to execute the drop first and then a CREATE...the pseudo code would be some...
SQL Server/T-SQL has a command "use dbname", so you can switch or make sure you're in the right database. What's the same command for PostgreSQL?
Groupshield is using a PostgreSQL database this process: "postgress.exe" is taking huge number I/O reads and it is causing the server to perform slow.
Background scanning and proactive scanin...
All,
I currently need to implement a trigger in PostgreSQL that executes on the update of a row that executes the following function name in my database:
Function_Set_Authorized("ID Parame...
We were doing regular vacuum of the site before and last week our admin deleted the cron for vacuum. We were running
full vacuum every night using this command:
vacuumdb -d db_final -f -z
...
Hello,
I am in need of a "for dummies" tutorial on how to import csv files (preferrably multiple .csv files) into a PostgreSQL database using Python and the psycopg2 module. Version of Pyt...
Written a function
CREATE OR REPLACE FUNCTION "spc_MemberIds"(text,text,int,int) RETURNS setof integer as
'
BEGIN
SELECT "iMemberId" from "Members"
where "ActivationStatus" =$1
a...
I want to install pgadmin (the postgres admin tool) on a CentOS 4 system.
I initially just downloaded the rpm, but I ended up in rpm hell where it required wxGTK and then when I tried to in...
Ijust ordered a new server with Sever 2003 64-bit edition on it, and then we found out that one of the applications that we need to use on this server has not been tested to work in a 64-bit e...
I am using postgresql 7.x and thought the following would work, but it does not. It seems to me that similar syntax works. What am I doing wrong?
DatabaseError: error 'ERROR: cross-databa...
I am trying to INSERT a record in my postgres table and I get t his error:
ERROR: array value must start with "{" or dimension information
My table definnition
CREATE TABLE paymentmethod...
I am getting this error on one of my CSV file imports. I have tried deleting everything from the end of the rows and columns, but to no avail. What causes this problem?
ERROR: extra data ...
Hi!
We have a problem with Geoserver, PostGIS and MapBuilder.
Our map displays fine, but we noticed a lot of instances of postgres.exe in the task manager, simultaneously, mapbuilder f...
I have the following:
- windows xp running
- postgres SQL database using UTF-8
- ODBC connection to postgres database, assume data soucrce name is BOB
- a program which retrieves...
I am in a need to denormalize a table.
Supose the following two tables:
Jobs:
jobnumber varchar(12)
author int2
JobStatus:
jobnumber varchar(12)
status int2
statusdate timestamp
T...
Hi Experts
It will become apparant real quick that I am clueless on most computer topics. However, being an accountant in a rural area, I need to learn programming and databases. I won't bo...
We are using postgresql db for our web based application. We are using postgres stored procedure extensively and we have a requirement where we need to pass arrays to postgres stored procedure...
I downloaded and installed postgresql-8.0.3.zip from http://www.postgresql.org/ftp/binary/v8.0.3/win32/ . I have created a database with sql statement as below
CREATE TABLE my_table
(
"...
How do you change the column size in a populated table?
Hello
I am using pgadmin to backup a table in a postgres database. When i try to restore the backup file to same server it was created to a new test database i get the below error.
C:\Prog...
When I try to run an application that does lots of updates and inserts in parallel, I get deadlock detected error messages on a regular basis (one every few seconds with 20 threads).
The er...
I installed postgreSQL 8.2 on windows xp and am now unable to uninstall it. I think it has something to do with the user account it created. I don't have permission to uninstall it as a user, ...
Hi.
I am trying to create a sql statement on a table that would calculate the standard deviation of the daily returns for each Ticker I send to the function.
table
Date Ti...
Hi.. I am setting up a VPS, and am having some issues with PostGres and php..
I get this:
Fatal error: Call to undefined function: pg_connect() in
I have installed PostGres.
I have u...
