i'm using a poker program that uses PostgresSQL 8.3 for its database. Works fine. I want to access that databsse from my laptop over my wireless...

Arizona Willie

03-29-2010 05:39 PM
Arizona Willie

Can anyone help make a base for me ? I just started going to school partime for database programming MsAccess. I have this job as well that I just...

trunorth36@yahoo.com

09-30-2007 03:07 PM
trunorth36@yahoo.com

I am about to upgrade from RHEL3 to RHEL5 and they seem to have postgresql (8.1.9 so far) as a database management system as one of the...

Jean-David Beyer

06-20-2007 06:17 PM
Jean-David Beyer

If I have multiple SCSI hard drives, is it better to put the indices of a table on the same drive as the relation (table), or is it better to put...

Jean-David Beyer

06-19-2007 09:12 AM
Jean-David Beyer

Hello, We are running PostgreSQL 7.4.7 on a Linux system. We have a primary DB and hot-standby . A few weeks ago we had a database corruption and...

Shahryar G. Hashemi

01-01-2007 04:29 PM
Shahryar G. Hashemi

What is the correct data type to store an image in? In MSSQL it's "Image" what would be the equivalent in PostgreSQL? Or what would be the...

ComCast Technical Groups

12-29-2006 10:55 AM
ComCast Technical Groups

Hi- Newbie to postgresql. I download and complied 8.15 on RH 9. I wrote a trigger that records the actions of customer table into a customer history...

Melvin Toy

11-05-2006 03:23 AM
Melvin Toy

Ok, I am coming from a mysql background, which I have used for a couple of years. But now I am wanting to try out PostgreSQL as a...

Terry A Haimann

11-03-2006 11:07 PM
Terry A Haimann

HI Is it possible to call CREATEUSER in VB.Net code so that a user password is added and there is no prompts Thanks in advance

Nevikski

06-16-2006 02:27 AM
Nevikski

Anyone have any definitive differences betweeen these two databases in terms of performance, scalability, ease of use, utilities, etc? I'm looking...

Jim Morrissey

05-15-2006 06:07 PM
Jim Morrissey

I just installed PostgreSQL 8.1 for Windows 2000 (NTFS file system). It was created with the default Postgres administator, "postgres". I then tried...

John Green

04-23-2006 01:39 PM
John Green

I have a problem I am trying to solve. I have a rather large application that uses Postgresql. For performance reasons I would like to run it on...

Chance Ginger

04-19-2006 06:42 PM
Chance Ginger

I know nothing about databases, SQL, or PostGreSQL :-) I installed PostGreSQL and phpPgAdmin on a web server. It looks like PostGreSQL insists that...

John Oliver

04-18-2006 11:09 PM
Schmidty

Hi everyone. I'm working in Windows with PostgreSQL, and I have created a simple C function in a DLL, which contains only the...

Pegasus86

04-09-2006 05:47 PM
Pegasus86

If I have a large file >200kb that is an encoded binary file, is it better to put it into a bytea field or text field? is there a performace/...

Chason Hayes

03-28-2006 09:06 AM
Pegasus86

How to select records from a choosen year? Something like this select myfield from mytable where year(myfield)=2006 Regards R. Stormo

none

03-05-2006 01:58 AM
none

I had a table that has about 3 - 4 million records which i frequently update flags in. I noticed the table growing huge and did not seem to shrink at...

BILLY ZITO

02-12-2006 11:44 AM
BILLY ZITO

Hi. I'm new with PostgreSQL, but this thing doesn't allow me to sleep: I wonder if it is possible to execute SQL query which: 1. checks out if...

Bartosz Jakubiak

02-01-2006 09:55 PM
Martineau Luc

I'm building a little app for mysql and would like it to work on postgres as well. Problem is I use a "SHOW PROCESSLIST" query, which is not standard...

Matthew Crouch

01-02-2006 01:36 PM
Matthew Crouch

Hello, I'm interested in using the DatabaseMetaData Object to get information about all of the sequences in the current database. Information I...

tsmango

12-21-2005 02:13 AM
tsmango

Hi I am trying to figure out how to select the names of the tables in a database when given the name of the database. I get easily select names of...

Jeff User

12-17-2005 01:02 PM
Jeff User

Hi, I've been working a lot with MySQL for quite a while and now I'm trying to get into PostgreSQL. One problem that I still have and could not...

Markus Popp

12-03-2005 07:28 AM
Linker IT Software

After looking at many of the DBMS choices out there (commercial and open source), I settled on PostgreSQL because of its stablity and...

supersize me

10-17-2005 10:48 PM
supersize me

Hi! Can you please name some Wiki engines that run on Linux and are based on PostgreSQL? Thanx, Georgo Gormez

George Gormez

10-08-2005 02:12 PM
George Gormez

How can I execute a query which prompt the user for input? Something like SELECT FROM Table WHERE Name= In Oracle PL/SQL, you use & before variable...

Jack Bauer

09-24-2005 05:54 PM
Jack Bauer

Hi, I'm trying to translate from mysql to pgsql one query as below SELECT DISTINCT name FROM table ORDER BY surname

gniewosh

09-17-2005 11:35 AM
Luc Martineau

Colleagues, On postgresql-7.4, pg_restore fails to restore a database because it tries to create some views referencing other objects which is has...

Victor Sudakov

09-16-2005 12:31 AM
Victor Sudakov

Any ready-to-use instalations/compilations (not source code!)? Regards

VD

09-12-2005 08:01 AM
VD

Hi, all, I am looking for the 1991 and 1992 Black Box Catalogs. I am will to pay $$ for them. If you have one, please email me. Thank you. Tom

Tom Smith

09-11-2005 11:06 AM
Tom Smith

What is it? A web application for job opportunity tracking. It helps you organize the jobs you have applied for as well as notes about your job...

Scott Auge

08-30-2005 01:25 PM
Scott Auge

I run an xp program in vmware that uses a postgresql db. I want to back up this db from linux. The cmd I was given to backup the db from within xp...

Mike Ballard

08-30-2005 12:05 AM
Scott Auge

I'm trying to accomplish the following: GRANT all ON friends TO www-data; however the - sign in www-data seems to be a problem, how should I escape...

Hugo Coolens

08-18-2005 01:19 AM
Hugo Coolens

Hi is there any way to revice value of autoincrement column. lets suppose that we have to tables: 1. document (id serial) 2. document_positions( id...

RobertK

08-14-2005 11:25 AM
Scott Auge

Sorry for the seemingly novice posting, but I could find a solution for this on the web so far... I've been developing a database using postgresql...

Jeff D. Hamann

08-03-2005 11:05 AM
Jeff D. Hamann

I am looking for comments on something that lets me abstract database updates in an object. Lemme explain what I am thinking: Lets say I have an...

Scott Auge

07-15-2005 12:23 PM
Jerry Stuckle

Hello, i can't find any matching answer for this question. How to construct SQL query to list all tables in current database? Let's say i use the...

Mariusz Kaczmarczyk

07-05-2005 09:08 AM
Mariusz Kaczmarczyk

Hi all, I am starting up an E-Zine detailing development ideas and the like concerning PHP and postgresql. This is a freebie but it does have...

Scott Auge

07-01-2005 02:02 AM
Scott Auge

hello I have database with 20 tables, but I want to do backup only 10 tables pg_dump include -t option, for example: pg_dump ... -t table1 can I do...

RoB

06-26-2005 11:28 AM
RoB

Hi, I am hitting an issue when using SCROLL CURSORS. -->My Setup: PostgreSQL 8.0.3 on Windows XP Pro SP2 -->My Test Function: CREATE OR REPLACE...

Larry Morroni

06-21-2005 03:56 PM
Larry Morroni

I have a server under very light load -- just me doing some work in php. I am getting this error often and don't know why: postgresql max...

Dan

06-10-2005 04:45 PM
Wiseguy

I've got a little issue - when I run for example "SELECT * FROM test" my result is: id name 1 first test 2 second test but when I create...

06-09-2005 12:01 PM

Hi, I installed PG 7.2 and have a database "foodsvc". I want to make a new copy - "newfoodsvc". So that I can play with the "newfoodsve"...

G Lam

06-05-2005 10:10 PM
Wiseguy

Imagine I have built a program based on PostgreSQL. There is a statement that anyone can use and distribute or modify PostgreSQL software...

Marcin Karbowniczek

05-22-2005 06:56 AM
Marcin Stêpnicki

Hi there, I'm coming from a MS-SQL/MySQL background, and am trying to understand the way Postgres phrases "stored procedure" type stuff. What is...

Jaye Gallagher

05-17-2005 01:15 AM
Jaye Gallagher

Hi there, I am a complete newbie in PostgreSQL 8.0 and I tried to install it on a W2K machine (no access to Linux sorry). I have a major problem:...

JC

05-13-2005 02:47 AM
JC

I want to order a text field which contains some words which begin with a single quote, if however I perform the following query, the single quote...

Hugo Coolens

05-10-2005 09:29 AM
Hugo Coolens

I'm using ver. 7.4.6.1 from a generic install of Fedora Core 3. I always get "permission denied" error when using the COPY command to load to a...

cbb

05-07-2005 08:43 PM
cbb

Hello all, I have a table with about 400,000 records and a btree index (numeric). A simple SELECT * FROM table WHERE id = ... takes more than a...

Alban Hertroys

05-06-2005 10:10 PM
no-spam

I want to calculate the duration of time for a timecard project. This is a sample: totaltime = (endtime1 - starttime1) + (endtime2 -...

Tony Pack

05-06-2005 09:59 PM
no-spam

Hello I have 2 databases on PostgreSQL, for instance base1, base2. I connect to psql: psql -p 3333 base1 how can I access to base2 ? for instance I...

RobertG

05-06-2005 01:32 PM
no-spam