how do you convert a column data from decimal to hex and vice versa...thanks
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.
This is in Postgres 8.3
Have table 1 (order_it,customer_id, product_id, amount) over 100 million records
Have table 2 (order_id,date_ordered,date_sent) over 250,000 records
We can easily ...
I am running a software package that uses postgresql 8.1.4 on RHEL to track delta changes. I know very little about postgresql other than how to install it.
My postgresql \var\lib\pgsql\dat...
How do you identify the end of a cursor in plpgsql?
Oracle:
WHILE mycursor%FOUND LOOP
END LOOP;
How to do that in plpgsql ?
-g
In my searching I have been unable to come up with a satisfactory explanation of how Postgresql handles case sensitivity with the names of tables, columns, etc. This doc page
http://www.pos...
I need to create a postgres function with a query having the table name variable.
This is a example of what I am trying to do:
...
$BODY$
DECLARE
tabla varchar;
BEGIN
tabla:= 'res...
Hi there,
I'm experimenting with PostGres, and being primarily a MySQL user, I'm running into some syntactical issues.
In MySQL, I'm able to do something like this:
INSERT INTO myTabl...
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/...
I know from MySql that there are tools and commands to control processes that PostgreSQL is working on. What would be the equivalant solution in PostgeSQL be?
I want to see which query is bei...
In this post :
http://www.experts-exchange.com/Databases/PostgreSQL/Q_21678003.html?query=postgres.exe&clearTAFilter=true
the Accepted Answer from earthman2 states:
"explicitly close yo...
Using the Corelab's .net driver for Postgres in VS2005 to hit our production database. I've been developing against MS SQL server and using the Gridview Data Source wizard option to Generate t...
I am using this copy function and want to make it part of a script deployment. Is there a way to reference the current directory the script is in as the path. For instance, I could place thi...
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 ...
The table has just less than a million rows.
vacuum analyze is done daily following an insert and delete.
If i run a select max(any one of the 200 or so numeric columns in the table) from pm...
I have a performance problem with a prepared statement. Executing the prepared statement runs 800 ms(consistently). The sql statement takes less than one ms. It appears that the prepared stat...
If I have a table 'TABLE' like the following:
FOO BAR BAZ
----- ----- ----
A Y Z
B Y Z
B Y Q
C Y Q
C Y Q
I would like to write ...
I am trying to create a trigger in postgresql using the OLD record
basically the column I want to refer to will be in a string for example:
myColumn = "some_column_name";
OLD.myColumn
...
Hello,
I have to load an xml data file into postgresql database table.For that I need to write a pl/sql procedure to load xml file data in postgresql table.And it should for any...
I'm trying to do an update with join in postgres. Postgres does not support the style I'm used to in MySQL, MSSQL, and Access.
There are 2 tables in involved. I'm trying to update id_val...
Please help to solve this install on CentOS 5.1 64 bit machine.
make works - using ./configure --with-gtk --enable-gtk2 --enable-unicode
I also tried ./configure --enable-appbundle
Usin...
I have a Webapplication with Java and Hibernate using a Postgres DB.
On my server are two apps running:
1. The Webapplication
2. An Import for the Webapplication, also with Java and Hiberna...
Hello, I would like to delete all data from all tables from an existing PosteGre Database. I would like to do it from within pgAdminIII. But I do not want to remove the tables, only the data ...
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 =...
