PostgreSQL Database Forum

HI All, I want to know the command that will display all the execution plans which are generated by the parser in PostgreSQL. Is there any command to instruct PostgreSQL to choose a specific query plan. Regards Vijay

Hello, Anybody aware of a multi-threaded test suite for Postgresql? Thanks, Neelam

Hi all :rolleyes: I had create a table in postgresql like this: create table image { pic_id integer not null, picture oid, };

Hello I want to upload many files with .spu extension (80000 files which has metadata) in raw format in to a databases using postgresql Can anyone suggest me way to do it.Waiting for your replies.

Hi I am trying to connect to the postgresql and make quries usuing my application in c language using the libpq library. I am using turbo c borland compiler. Can someone tell me how to setup the enviromnet and where to place files so that I can run examples given on the libpq site. Regards

I am trying to insert a large object into my dbs using: INSERT INTO table VALUES (lo_import ( ' z/image/image.jpg ' )); but i get the message saying that I need superuser privilidges to do it and that I should use client-side \lo_import command. Does anyone know how to use that command? And what is the syntax for \lo_import and export...

hi all i use postgresql database. There are two databases in that namely 'db1','db2'. In 'db1', thers is a table named as 'table_common'. In 'db2', there is a table named as 'table_common'.

When through one webservice we are doing "update" operation and before doint "commit" , that instance crashes..now if i want to create some recovery service..i need to release locks ..but when i try to release locks using same username and password, they are not releases since we submit "rollback" command , we are indirectly creating a new...

Hello Friends, In a Table I am inserting more than 50,000 Records one by one. It was taking a lot of time . Is it There any good approach/solution for inserting records more than 50,000 one by one in a fast manner. I have the same Problem in Updating of Records also. Please help me regarding this issue. I am Using VC++ application As a Front...

Hi. I've been looking for a function similar to MySQL's sha() function in Postgre and I can't seem to find anything. The reason is that I have a system that is written for MySQL and I've been asked to make it compatible with Postgre. Thanks.

Hi Friends, I am Using the libpq 'C' interface as a interface in my VC++ Application. Here I would like to take a back up and restore that database using the libpq interface. Is it possible to take backup and restoring the database using the libpq 'C' Interface. If yes please give/send the solution. ThankQ

I have been reading through all the threads and trying a few different things. Essentially, I have a function that loops through a table and then performs some updates/inserts against other tables based on the row from the FOR LOOP. Currently, none of these inserts/updates are visible to other users until the LOOP and function are complete...

i want to select a list of all user names and customer names. all names are in table 1 above. what does this sql statement look like? assume two tables: 1. t1, columns id (unique generated value), and name (some char value) for example, the t1 contains 1 customer name 1 2 customer name 2 3 user name 1 (at customer 1) 4 user name...

Hi all, I have a database (postgresql) designed with a particular schema. I have now set up a new postgresql database to store the same data (possibly some new info added) but has a different schema. (Basically, we have designed a new application and tweaked the database schema). The new db is set up using Java5 Java Persitence Architecture...

hi all i have a doubt Suppose I have a table employee in which i have 3 fields no name and salary I have stored 100 records Now suppose i alter the table by adding two more fields say dep and address will my old data lost or not

Hi, I'm sure I'm asking a very easy question, but I am currently in the process of migrating from MS SQL to PostgreSQL and I am facing a few issues, which I would appreciate your help/advice on : 1. Is there a way to overcome what seems to be everything turning to lowercase in a query? For example this was the original stored procedure in...

Hi, I am using postgresql 8.1 an I am trying to connect to the postsql from JSP and servlets in linux platform but I cannot find the driver name for the postgresql so I can use it in the jsp connection. I would appreciate your help. Thanks, neha

I'm trying to do some date queries on a table, and I want to know if there is some builtin variable within the date datatype which can represent that a day, month, or year could be any value. For instance, if the variable were "*", I could write: table.datefield >= '*-10-*' and any date in table.datefield which had the month 10, 11 or...

Hye, I'm quite new in postgres.I have 2 problems that i do not how to solve. Hope somebody can help me. 1. Although i put my zone field is unique, postgres sometimes redundant my data automatically.Example : ----------------------------------- rundate | zone ----------------------------------- 01/30/2007 | #01

Hi All, I have a system that stores information about a person, name addresses and so on and I would like to return a single row for each person in an SQL statement. This is so it can be placed in a view making it easy to obtain all information for person x. Since a person can have more than one address I thought I could build an array...

Hi All, I Made a window application in c#.net and trying to fetch the record from the postgresql database. But whever i run the application "String was not recognized as a Valid Date Time" message show. This problem is arries from the database when it tries to fetch the record from a table in which timestampz datatype is used. so plz help me to...

When i try to execute this command CREATE TABLE "public"."tblIterator"("IteratorID" int4 NOT NULL DEFAULT nextval('"tblIterator_IteratorID_seq"'::regclass),"InitializerID" int4 NOT NULL ,"HasNextID" int4 NOT NULL ,PRIMARY KEY ("IteratorID"),FOREIGN KEY ("HasNextID") REFERENCES "public"."tblCode"("CodeID") ON UPDATE RESTRICT ON DELETE CASCADE...

i have a column which contains arrays of variable length. for example one array contains 5 elements, another contains 2 elements, another array 10 elements. i have 500 records in this column i want to select all elements of an array then below all elements of another array and so on in a normal column. this is very urgent if some body can...

PGDRIVER=org.postgresql.Driver PGURL=jdbc:postgresql://172.18.1.19:5432/test I am try to connect to pgsql but i am getting this error in windows XP Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl. But if i use

i need to migrate data from a excel to db using java codes. if there is any site where i can find a solution for this?