Hi,
I am running a database on my machine. but i forgot the database password i still know the username.
and if i go to pgAdmin i see that the database is running and that the password is...
Using Openser on Redhat ES4.0.
Postgres 8.1.3 was installed post Linux install (put into /usr/local/pgsql).
Following openser installation, we have error when starting openser:
I get "ERROR...
Hi all
How to migrate data from Postgre to MS SQL Server 2000 on Windows 2000 /Advanced Server?
Thnx
rahool
Hi colleagues, I'm looking for an easy to use ide tool for developing plpgsql procedures ( other than pgAdmin which is best suited for DBAs ).
Thanks in advance, Esteban.
1. i've created the following function in postgres.
CREATE OR REPLACE FUNCTION get_level_between_dates(in_container_id integer, "start" time with time
zone, "end" time with time zon...
I am new to OpenSource GIS, but a GIS developer for many years.
I am going to be working with nationwide, and eventually worldwide datasets. For now, I have a huge set of point data with l...
Hello,
I'm creating a web-app in Netbeans using Tomcat/JSP (with CachedRowSets for manipulating data) and the PostgreSQL database. So, I want to to create a page where I import some data in...
i have a table called road
It has
select count(*) from road;
count
---------
1098822
I want to fire this query in the database
select name, astext(the_geom) from road where ...
Hi
I installed 8.1.2 RPMS on my system. When I tried to run /etc/init.d/postgresql start I got this error.
/etc/init.d/postgresql start
Initializing database: mkdir: cannot create direct...
I can't seem to see any commands in the stats tables despite setting stats_command_string = true. I can't stop it from saying ' <command string not enabled>'. I am running as the superuser.
I am printing the table values which is in a for loop via java programming. I cannot seem to convert the string from the database into a String variable which compares using the java String.eq...
I have a database table created using this command:
CREATE TABLE ratings ( uid int NOT NULL REFERENCES utable(uid), mid int NOT NULL REFERENCES mtable(mid), rating smallint NOT NULL, rdate ...
Hi
Is it possible to backup the structure of a Postgres Database, I normally use the pgdump command for a backup but then the structure and the data is backup. I want to replicate the DB ...
Hi,
I'm running into the following error when I try to pull data from my postgres database:
SchoolManager.java: readSchoolsFromDB(): Error while reading all schools
org.postgresql.util....
I have a table like this:
CREATE TABLE Foo (
id1 integer,
id2 integer
);
Each row is unique and is used to store the relationship between two entities. So, for instance, giv...
Im struggling to configure php + odbc + postgresql, any input greatly appreciated.
Here is what I have so far:
test-odbc.php
<?
$U = "testuser";
$DB = "testdb";
$P = "pass";
$Srv =...
I have a Postgresql database with a table that has a column that contains TEXT datatype items. There are only a number of possible variables. Would it be more efficient to use another datatype...
In PostgeSQL, I want to create inline functions like I have in other RDBMS'.
I want to be able to pass in a name field that has the format of: Last Name [space] optional Name Suffix, Firs...
I'm trying to create a view in postgresql so that my Zen dFramework app can query it.
I get the following error
ERROR: column "name" specified more than once
I'm not quite sure what ...
I want to sort my data by a date field in such a way that the dates that are not in the past are sorted ascending, and the dates that are in the past are shown after all the non-past dates, in...
Although I'm not entirely familiar with update with inner join query syntax for Postgres, I've come up with this by reading online docs. You'd think that this should work but it doesn't. I g...
Dear experts,
I'm New to Linux and Postgre.
I've installed PostgreSQL 8.2 and phpPgAdmin in Ubuntu
Now, please tell me how to start phpPgAdmin
Thank you
I'm having a problem with a Gridview's update statement in VS2005/Postgress SQL server. On testing this on my local PC running VS2005, and hitting a Postgres SQL server on a differnt box. I'm...
I cannot get libpq,PostgreSQL's C API, to compile a debug version, though it will compile a release, so I've copied the release folder, renamed it debug and appended a "d" to each of the dlls/...
Navicat has a great admin tool for PostgreSQL, especially when working with the Import wizard functionality. Does anyone know of a free tool or utility that I could use with pgAdmin III that ...
