PostgreSQL Database Forum

Hello, I wrote C program for connecting to postgresSQL server to retrieve data from the postgres database. The program is: #include <stdio.h> #include <stdlib.h> #include "libpq-fe.h" int Search(inStruct Sentries)

Hi there, Is it possible to create nonclustered indexes? If so, how? Best Regards

Hello Guys, Does any of you have a script for creating a sample database witch will include all kinds of objects that postgres suports ? I will be very glad if someone can help me! thx

Hi everybody! I have two questions concerning postgresql indexes: 1- Does PostgreSQL support bitmap indexes? 2- How does one create GIN indexes? (If you could give me an example, that would be great) Best Regards

Hi , Our current windows application uses postgre 8.1 while next release will be using postgre 8.3 Naturally when application is upgraded ..postgre is expected to upgrade To support this upgrade we will be taking following path: 1) run pgdump & take backup of existing database

Hi all, I'm wondering if someone could explain how can I run two different versions of Postgres (8.2 and 8.3) on the same server machine, point any websites or resources that discuss such problem. I've googled for more than two hours and could not find anything well explained. Thank you.

Hi All, Please guide us, Autobackup available in Postgresql. Thanks & Regards, PandiaRajan A

Hey folks! Can anyone tell me how to add data to a table using "copy" with several delimiters? Is it possible? What i mean is: Copy <table_name> from <file_directory> using delimiters <delimiters>; How its done the "<delimiters>" part? I tried several ways but i got out of ideas...

Does anyone of you Experts try to change postgres source code so that it would be available to perform the undelete command (restore deleted rows when no vacumm was called)?

Hi All, I am not sure how to change the date format in PostgreSQL. I have the dates stored in the database as yyyy-mm-dd HH:MM:SS+TimeZone to get the GMT time (Ex: 2008-02-28 14:03:23+05:30). But I want these dates to be shown in the following format: dd/mm/yyyy HH:MM:SS TimeZone (Ex: 28/02/2008 14:03:23 IST)So now while I am trying to fetch...

Hello, I'm currently working on an order management system that uses PHP and PostgreSQL. In my situation, I'd like to be able to use a cursor in order to do pagination. My PHP script checks (by cookie status) if a cursor has or hasn't been set, or has to be changed. If one hasn't been set, or it needs to change the SELECT statement, it...

Hi, I made a blunder mistake..i have deleted some 100 rows from my table in postgres and that is very important in my project..pls give me a solution how to recover those deleted data ..i dont have any dump of that table.... thanks in advance

Hi thescripts team, I would like to ask for your help once again regarding returning set of records in plpgsql. I followed examples presented in other sites regarding this function but my script doesnt work. here's my code create or replace function find_postal(varchar, varchar, varchar) returns setof record as ' declare ...

Hi friends, Can you help me for how to use regular expressions in select query? with an example. Please help me.

plj help me to know how to use stored procedure in postgresql and its advantages.......

Hi guys, I have the following query: (SELECT extract(hour from request_time) || ':00-' || ((extract(hour from request_time))+1) || ':00' AS time, count(*) as hits FROM log_request GROUP BY extract(hour from request_time) ORDER BY extract(hour from request_time)) UNION ALL (SELECT 'Total', count(*)

Hi, I am trying to develop user interface in CGI-PERL using CGI.pm module with DBI.pm module. while a form value is submitted to cgi program it is showing follwoing error "Couldn't connect to db1:5432/tcp: IO::Socket::INET: Permission denied at /usr/lib/perl5/site_perl/5.8.8/DBD/PgPP.pm line 124" Code is below #!/usr/bin/perl -w

Hi I have few questions. Pleae give me the answers. 1) In postgreSQL, how to declare and call the cursors in a stored procedural function? Ex: I want to display all the columns in a table in one cursor and also how to see the output. 2) tell me , the analytic functions in oracle connect by prior, sys_connect_by_path are existed in...

How to save bitmap image into postgreSQL this is my id........

Hi, I have delphi database application through delphi7 database postgresSQL8.1 and zeos6.1.I have two postgreSQL8.1 database server.One is windows server working local network another one is linux remote server.When i make the data entries want update the local and remote server.How it is possible through Zeos component.I am apperciate your...

Hi I have the postgreSQL version 8.3.0-1. When i am trying to install it on Windows XP, it giving the error as Internal account lookup failure: No mapping between account names and security IDs was done I have given the in the service configuration fields as Account name:san Account Domain:I Account password:databaseadministrator

how to prevent users to use the specific databases. i mean i have lots of databases. so i want the particular user use the specified database only. is it possible to have password in the database to lock. thanx

hi experts, can a function be triggered every day. for example if i want to run a query everyday, how can i write a trigger. i wrote a trigger which runs only when some event occurs but i need it to run automatically say in the specific time lets say. thanx in advance

I am accesing the postgresql server using pgAdmin III tool, and trying to drop the database then I am getting an error as: Maintenance database can’t be dropped. ERROR: database "postgres" is being accessed by other users SQL state: 55006

Hi All, I have the following query which was based on a working query in MySQL: (don't be afraid of the size of the query you see below, later on I will concentrate on part of this query) SELECT count(*) FROM ((SELECT * FROM tileinfo where julianDay BETWEEN DATE2JDAY(('2003-03-01 00:00:00'),0) AND DATE2JDAY(('2003-03-01 23:59:59' ),0) AND...