PostgreSQL Database Forum

Someone know how to create database in postgreSQL through Java code? How to check particular database exist or not in postgreSQL through java code?

i am working on java this my code.i want to get the no.of records from database. class Model{ public int records{ int count=0; try{ Class.forName("org.postgresql.Driver"); con=DriverManager.getConnection("jdbc:postgresql://localhost:5432/samyu","samyu","samyu"); }catch(Exception e){

Postgres voilates Primary key .I would be able to find duplicates on database. Also it voilates the OID.I dont know the reason .it happend only once on DB. Please suggest me is there a soultion to avoid this on future. I have manually deleted the records then it started to work fine. During this time. I have lost few records in database...

Hi I'm trying to migrate a universe database to postgres, so far I've exported the tables from universe using uvexport into a comma sep. text file. I've converted the file to CSV format and all's well apart from a table that contains dates. Date fields in the exported file are shown as 5 digit numbers eg. 10655 which should = 3/3/97. Postgres...

Hi I am writing a function with PL/pgSQL, which returns result of some complex query with several tables. In manual i found such example: CREATE OR REPLACE FUNCTION Test() RETURNS SETOF table1 AS $$ DECLARE ret_row RECORD; BEGIN FOR ret_row IN SELECT * FROM table1 LOOP RETURN NEXT ret_row;

Hi, I need a help with PostgreSql. I need to build a function that returns the folowing select and I don't know how to do it. thanks. jose Souza "Select pe.pessoa_id, Pessoa_Nome, pessoa_alcunha, sexo_descricao,

this is regarding C trigger function in postgresql 8.2 The function trigf reports the number of rows in the table ttest and skips the actual operation if the command attempts to insert a null value into the column x. (So the trigger acts as a not-null constraint but doesn't abort the transaction.) First, the table definition: CREATE...

Hi, I would like to run shell scripts with respect to the time mentioned in postgres data base tables. Postgres database should trigger the shell script for the time mentioned in the table. To make it more clear, i will add an entry like as below in postgres database table file_id script_run_time crd_extract.sh ...

Hi to all, i am currently doing a web application. I have a form that contains about 100 radio button and 100 checkboxes. my question is, how do you design it in the database table? should i make 200 columns (100checkbox,100 radio button)? Need help on how to design this. Thanks.

hello all, i want to fetch data from one colomn and copy it to the column in a different table..the database is postgres. please tell me how to do it.. thanks and regards,

Hi I am using PQgetvalue() function in c to get the value like PQgetvalue(result,0,2) but the program outputs column number 2 is out of range 0..0 Can someone tell me how can I get this field and whats wrong?

Hi How can i put ditto when i had same number in consective rows,kindly help me its urgent.

Hi, I'm trying to put together a query that will order entries in a table by the rating values which decay over time. I'm not too well versed in the intricacies of Postgres, or complex queries, but I've cobbled the following together: select * from entries order by ( select sum(-rating_value * exp(ln(0.5)/43200 * ...

Hi, I am getting the parse error while i try to execute a simple sql query in postgres. java.sql.SQLException: ERROR: parser: parse error at or near "and" at character 58 The Query has been changed and it is very much like the below one select * from emp where empName like 'XXXXX' and empId=206

I have a database(PostgreSQL) table(about 70k rows).I am developing an ASP webpage and there is a list-box on it which contains the name of the columns of that table. User selects the column name from that box and a query is sent to the database. The data from that column should be returned to the user. Now the problem is that, I have seen...

Hi.. In my project i have create table,Storeprocedure,view..etc., in oracle now i have planed to move all the data in oracle to postgreSQL.. Can any help me how to transfer the all the data from oracle to postgreSQL.... Thanks in Advance... Reg Inbaraj

hai this is sonu. i am new to thiss. i have a doubt in creating table. in creating tables we are taking some key words. my doubt is how asighn key words (primary and forign key) to names in a table. ex: i am creating 3 tables about employee leave table, leavetype table, manger table in this 3 tables emp code is primary key and leave date...

Hi I have a problem with the Foreign key in Postgres 8.1 under Windows XP for example: I have PERSON table as a superclass and PERSON_A, PERSON_B, PERSON_C as subclasses Table_X as an ordinary table Then I want to link Table_X with PERSON_B, PERSON_C tables with a Foreign key which is id_no which is PK in the PERSON_B, PERSON_C tables ...

I created a table in which i dont have a primary key ,so i want to give oid as primary key .In the table i have some thousands of records. How do i generate oid for each record?

hi friends I have been doing testing on an existing project The tables in postgresQl Db has some trigger function using keyword 'DELETING' IF DELETING THEN SOME SELECT STATEMENT END IF;

Hi, Friends I have a table with 2 lakh records (one text field, one int4 field, and a Gemetry field). When I was executing the query using Binary cursors, It was taking nearly 35 seconds. I am executing my query as follows BEGIN; DECLARE MyCursor BINARY CURSOR for select Field1,Field2(Geometry Field) from Table; Fetch All into MyCursor;...

ERROR: returned record type does not match expected record type HI friends what does this error means M not able to figure out

Hi I am using postgresql 8.1 under WinXP I want to ask about the inheritance strategy of the postgresql Is there a real redundancy of stored data or not? Because after I had made the inheritance, I noticed that all of the superclass attributes have been appeared in all its subclasses :eek: And I have only to insert the data in the last...

hi friends Well i am trying to create a query which uses a subquery in the from clause I want as soon as the subquery fetches a row the , the subquery should stop executing , beacuse the table used by subquery has 40 million rows THIS is so far i have been doing SELECT column FROM some_table WHERE EXISTS (SELECT * FROM some_other_table...

Hi every body! please show me the way to implement load balancing in postgresql, with 2 or 3 servers DB. Thank you so much.