[postgresql] Forum Topics

how to copyng data from another database postgre to mySQL database without cronjob with realtime... php can do it..? thanks

Hi, When I execute queries which have a lot of data returned in the recordset my VB app seems to hang (IE: This program is not responding) I'm using ODBC to connect to the database and am using Postgres DB [CODE] Public db_name As String Public db_username As String Public …

Does anyone know of a free tool or utility that I could use with pgAdmin III that would accomplish the same type of import functionality found in Navicat?

hey ppl i'm using postgresql for backend.. once i connect it to the sever it should disconnect and all the update ,edit should be done offline and others should not edit the data in which im working.. for this i can use FOR update clause,, ???? can some one suggest …

i need connect postgresql with vb, i cant figure out how to do it need submit proj soon. Plz can any1 send me z code and explain how it wrk, coz wana undrstand the connection n nt just copying

I'm not sure it this is a post for PHP or the database forum, but since my question deals with php functions, i put it here. In the past when i would page results i do the following: 1) get the count of my full resultset 2) calculate limit and …

Hi: I am trying to implement a distributed database application with Postgres similar to one that I've in Oracle. I can't find an equivalent Oracle DATABASE LINK in Postgres. Does any one know how to connect two remote sites in Postgres? Thank You. [email][email protected][/email]

Dear all, Here is output of my command -bash-3.1$ psql -l |cut -d "|" -f1 | grep -i repo repository repository_reports $ I want to drop these database thru script one by one. My requirement is to take the these o/p one by one and use it with dropdb command. …

I have been working on a program designed to read information from an Access database and display it on the screen. As my main development box doesn't have a copy of Access on it, I copied the data over to a PostgreSQL database and attempted to work from that. Now, …

I would like to take back of my database of postgress. now i am doing the command "pg_dumb " which written in a shell script and run it on command promt How it will do with PHP? Can i use that shell script in the PHP? Is there any need …

[COLOR=Red] want a php class to take back up and restore of my database (all tables) using posgress with status bar. help me??[/COLOR]

I am in need of web template engine and I am considering two options. PHPSavant and Smarty. I am using PHP ver. 5 and PostgreSQL database. PHPSavant supports PHP5 only in beta2 version, so I am affraid of some serious bugs, but at the other hand, as far as I …

I have a problem with my asp script that used to insert a data to postgreSQL database.This is the script : <% Dim sConnection, objConn , objRS ,sql sConnection ="DRIVER={postgreSQL};SERVER=localhost;database=sury a;UID=postgres;PASSWORD=admin;port=5432" Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open(sConnection) sql="insert into test(number,name) values('3','abcd')" set objRS = objConn.execute(sql) objRS.close Set objRS = Nothing objConn.Close …

I have developed a database model for an organisation. This organisation has departments that do the same type of work so the schema I designed for one department is the same everywhere. But they are spread in different geographical locations. I have used PostgreSQL v8.2 as the back end and …

Yesterday, I was attempting to reload a remote copy of a postgresql database that had been corrupted. Creating the new db went well, as did reloading the data schema, but somewhere during the reload of the data itself, I lost the remote connection. After killing the now-unworking putty connection and …

Hi, I have written a jsp file to fetch data from a database table and display it in the form of a table in jsp. The idea is to generate a dynamic table. I have written the following code. <%@page import="java.sql.*"%> <html> <head> <title>The alert table</title> </head> <body> <h1>Alerts</h1> <% …

ive been trying to connect my c program and a postgre database using VC++. but i cant compile it because it cant find "postgres_fe.h". and also i cant find any tutorials about this one too. When i searched google, most are for linux. if anyone here knows some links to …

hi i need to connect the jsp page with database using hibernate framwork how to possible ? can any one have the example or source code for this it's urgent my configration is following hibernate+jsp+netbean5.0+tomacat server+postgreSQL database [COLOR=red][B][U]HELP ME URGENT PLZ[/U][/B][/COLOR]

hello i have my data stored in different Ms Excell sheets. now I am planning to make a database of the data i have. but i m confused whether to use Postgresql or mySQL for the same. i had plans to import data directly to Ms Access but there is …

Hey everyone, I have been told there is a way to get a users login name and their SID in C#, does anybody have code or know a very detailed and easy to understand site? What I am trying to do is this, when a user logs in my application …

i am facing some problems with the following code. initially the jdbc driver(jdbc 4/3) ws not getting registered...nw somehw that problem has been rectified.bt nw i m unable to connect with the database(PostgreSQL). The code i have written is as follows import java.sql.DriverManager; import java.sql.Connection; import java.sql.SQLException; public class Example1 …

I've been given a piece of buggy code to attempt reviving. At the moment, every time I run it, I'm getting this error:[CODE]Database handle destroyed without explicit disconnect.[/CODE] A quick google search reveals that this indicates I'm not closing a connection. I had trouble figuring out why I was getting …

Hai.. I need to connect a database called "Postgresql" with a jsp code. how it can be done? I need the connection procedure for that. plz reply me..

Hi, I am using postgresql 8.1 an I am trying to connect to the postsql from JSP and servlets but I cannot find the driver name for the postgresql so I can use it in the jsp connection. i hv been sujjested to use jdbc but cannt find advantage of …

HELLO HOW TO DISPLAY AUTO_INCREMENT VALUE FROM THE THE DATABASE TO THE PAGE. $result = pg_query($conn, "INSERT INTO novice VALUES(NEXTVAL('sq'),'$title', '$firstname', '$lastname', '$username','$password','$street','$town', '$city', '$postcode', '$country', '$mobile', '$email')"); if (!$result ){ print " Please make sure you put the right input in the field"; exit; } print ("Thank You $title …

I've been requested to upgrade a postgres system running version 7.4.9 to one running version 8.1.3. There is another system running 8.1.3 with the data that we need to transfer over to the 7.4.9 system. Both systems are running SuSE 9.3 linux. Is there some command I can use to …

hi i am tring to use connection pooling in java with postgresql database. in given examples, i cant understand these file names that is given to create InitialContext object, also that file names are different for each and every examples. how can i get those files, and what are those..? …

I am currently in charge of a running installation of the Slony replication procedure for Postgresql databases. I inherited this installation from my predecessor; I have no clue how slony works. I am in need of some kind of beginner's guide, if anyone knows where such a thing might be …

Hi all............. I want to get the database error cord return by the database, to identify the error message and other messages. I am using postgresql database, they have provided their error cords, but still I don’t have any idea about how to do this, please any one can help …

Hi every body.This is siva from china.My s/w using postgres sql data base.Hw to use replication concept in postgres sql>if any body knows pls reply me.Advance thks

How to connect postgres through c language please send me connection establishing statements and theoriical notes.I am into development of querry optimiser in that i have to calculate the cost of the query with respect to space search strategy.please tell me about this also

Does anyone know how to change the ownership of a view in a postgres database? I have no clue how to do so, and all of the solutions I've seen so far online don't want to work for me. Thanks in advance, -EnderX

I'm trying to run a perl script designed to update the database on a remote server from the copy on our main server. Both dbs are in postgresql and running the slony replication setup. Semi-recently, the server went down on the remote unit and had to be replaced; I was …

Has anyone here ever worked with the Slony database replication system? A while back, one of the (remote) servers we were running this on went down, and the server had to be replaced before we could get the DB back up. I was able to upload the database this morning, …

I've been requested to update a segment of a database, and given that it's kind of longish, I was looking for some way to directly write the data I've got from a file into the DB. I know it can be done via a third party; I have used Delphi …

I do not know if this is the right place for this message to go, but there does not appear to be a forum specifically set up for the users of the PostgreSQL database, so this was the best match I could find. Does anyone know what function or functions …

Does Delphi have any way to escape symbols embedded in strings? I'm trying to write a database project, and have just run into a rather nasty problem; the db I'm working with, PostgreSQL, refuses to recognize equality to date functions unless the value being tested is contained within a pair …

the database module of the Open Source project OpenOffice. We (they) are having difficulties with the code in the Base module which allows updateable queries. See [url]http://www.openoffice.org/issues/show_bug.cgi?id=53377[/url] . i have volunteered to comb the web and place announcements on different sites in order to encourage volunteers to help with the …

I am looking for a way to be able to setup a postgresql database on linux and mirror the database on a second server, keeping both databases syncronized in real-time. I'm not sure this would be considered a distributed database (although I'm open to suggestions on how to do that …

Hi, I need to use function: SPI_modifytuple HeapTuple SPI_modifytuple(Relation rel, HeapTuple row, ncols, colnum, Datum * values, const char * nulls) How can I get object Relation? If I insert NULL as relation function does not modify tuples. I have found an example, when the function was called by trigger. …

Hi there, Here is a (hopefully) convenient description of my situation: - I have a main folder, containing several subfolders. - Every (sub)folder contains one or more .xls - Workbooks. - Every Workbook contains one or more different Spreadsheets. - The workbooks contain some cells which have Hyperlink addresses to …

On my linux box, I have installed Debian GNU/Linux and Apache 2. I need to set up .htaccess with authentification data stored in Postgre SQL database. The problem is, that I can not find libapache2_mod_auth_pgsql. Only modules I found was libapache_mod_auth_pgsql (Postgres authentification Apache module for Apache version 1, not …

hi there. have come across this site many times in google results over the years and decided to sign up - it seems a really friendly board. a bit about me.. i'm currently a developer in the clinical sector, although im moving jobs in 3 weeks to be a (mssql) …

MySQL 5.0 vs. PostgreSQL 8.1 what is main diference? advantage? disadvantages?

Hi, all! How in PHP get ResultSet from function PostGreSql8.0.3(Windows) and how is constructed this PostGreSql-function? If possible, please, link to some example. Thanks in advance Nilov Serge

I just got a JSP hosting account and I'm wondering how I can connect to the PostgreSQL DB and execute queries. According to the host's FAQ, the database URL is: jdbc:postgresql://localhost/username,username,password .

Hi, I have installed postgresql-8.0.0 on my mandrake linux system.When try to create postgres user it say already exists. Further it allows to create the database and tables.But once i restart my system it says server not running . Also can anybody tell me what more addition changes are required …

Hi, Does anyone know which grammar class SQL falls under (e.g. LL(1), LR(1), etc.)? Specifically the grammars for Oracle 10g and PostgreSQL 7.4? I need to build a parser for each language and want to select the most suitable class of parser generator for the task. Once which produces Java …

I am a programmer for PriceComparison.com. And I have just solved something quite remarkable and hard to solve. For anyone who has any index using an int8 / bigint field. You should take time to read this. The problem start when we noticed that any query with that int8 field …

[url]http://builder.com.com/article.jhtml?id=u00320020624gcn01.htm[/url] From article: [ When to use MySQL] Why would you use MySQL over PostgreSQL? First, we need to consider the needs of the applications in terms of database requirements. If I want to create a Web application and performance is an issue, MySQL will be my choice because it