Hi
Where can I find a Postgresql ODBC driver for Windows Vista, if exists. I've installed their latest version but could not pick it up under the ODBC settings in Windows.
Thanks
Hi Experts,
I installed postgres - under a non-admin account through the installer for Postgres 8.3. The installer itself tries to start the service and cannot after the cluster is initializ...
Hello,
I need to copy one table (properties and data both) from one database to another. I am using pgAdmin III.
I tried doing it with pg_dump and psql, but I guess I don't have the correc...
Hi Experts,
I have an existing database and I want to "copy" it to another place - both with PostgresSQL.
I have succeded to export the data with phpPgAdmin as an SQL script file.
Now I h...
In PostgreSQL, when writing a CREATE FUNCTION statement, you can add the statement OR REPLACE into the CREATE line, so it looks like this CREATE OR REPLACE FUNCTION. This checks if the functi...
Hi guys,
I have the following code to create a trigger which updates column making_price on table style
based on column packaging_price of same table style and column price_4_garment of tabl...
I am new to postgresql. I know it doesn't do auto increment on index. I am not sure how to say this: how do I create a sequence on command line so that I can get the next index # in my table F...
Hi Experts,
I thought I fixed this - funny thing is - it was sort of fixed...
When doing INSERT statements, I use the following form with 'serial' columns (my customer_id column is a seria...
Hi ,
I am trying to write a query in Postgres, for inserting values into a table , however if that INSERT were to insert a row with a duplicate key, it should update the original record in...
I have two tables, A and B.
A has two fields, KEY_A and VAL_A.
B has two fields, KEY_B and VAL_B.
Values in KEY_A and KEY_B may overlap.
I want to select all records from A and B into a ...
A third party program generates a .sql script in a file which I would like to run.
In my Java app, I already have a connection in a connection pool to the database, and I'd like to use that...
I'm a bit nervous about running an update-inner join type query with postgres since it's different from MySQL and SQL Server that I"m used to (which is much easier). Last time I attempted thi...
I received some SQL commands to execute in order to create tables for a report that my Director is wanting. I executed the commands in Webmin on the server and I cannot see the tables it crea...
I have installed the latest PostgreSQL native Windows beta (8.0.0-beta4 using the Windows MSI installer) on a Windows XP Pro SP2 system. I accepted all of the installation defaults, as far as...
Hi Experts,
Is there a way to check if a table exists in a given database before I try to create it in ODBC for Postgres?
Thanks,
Mike
Is there a query that I can run to list all tables that depend on a certain table
e.g. all tables that depend on tblData
They currently have a foreign key defined and I would like a way...
I have a dump from a Postgresql database that I want to import into MySQL. Short of going through the whole thing (it's huge) and altering all the field definitions, is there any way to import...
We will be soon taking on task on implementing encryption to various fields of our Postgre database. Our question is on where should we store the encryption key? We will be storing names an...
I am outputting a table that has a user's response with the period of time that has elapsed next to it
John Smith | Yes (15 mins ago)
Bob Jones | No ( 12 days ago)
Sally Thom...
Hey!
Just started using PostgreSQL, use to MS SQL Server. Noticed Postgre does not have a varchar table datatype.
Tried using a character[] thinking a varchar is simply a character arra...
I've run into a problem which I'm having a hard time fixing... a few couple of months ago I've switched from a jsp reporting scheme to one using datavision. I've field tested it for a few wee...
Can somebody give me a simple example of a trigger function that uses a parameter in Postgresql. In a table I have a column 'updated'. When a record is updated, the updated-value for that row ...
Hello,
when I'm trying to connect to the postgresql database (located on the server) I receive following error : "No connection could be made because the target machine actively refused i...
Hi Experts,
Currently I am able to psql into a database without a password. I don't want this - I want to be prompted for a password - what's the fix?
Thanks,
Mike
Hi.
Im trying to create a java class that deletes all data in a db. When its done Id like only empty tables. The problem is that I dont know anything about the tables and the structure.
...
