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...
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...
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 ,
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...
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
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...
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...
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...
I'm using the following MS SQL select query that I need to duplicate in Postgres.
SelectCommand="SELECT Dat_Indexno, Emp_Name, Dat_Type, Dat_Resource, Dat_From, Dat_To, Dat_Note FROM Dato1 WH...
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
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...
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 Experts, I'm using the psql query editor - connected to MyDatabase. What is wrong with this? I've got a column defined as 'serial' as describe below - when I try to insert I get the error...
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 ...
I am having using inserting new values into what shoudl be a rather simple hibernate/postgresql map. I have created all my mappings in myeclipse using the hibernate tool. When I try to save ...
Hello,
I am trying to invoke a stored procedure in postgres from C# asp.net web app. here is the code. it's not working.
odComm = new OdbcCommand("editCountry", odbcConn);
odComm.Command...
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 Folks,
I currently have an outrageously complex query consisting of many nested subqueries and convoluted joins in order to produce a recordset of about a half a dozen rows.
This quer...
How do you change the column size in a populated table?
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 am creating a SQL Script in PostgreSQL. I need it to check if a function exists in the database and if so, I need to execute the drop first and then a CREATE...the pseudo code would be some...
I downloaded and installed postgresql-8.0.3.zip from http://www.postgresql.org/ftp/binary/v8.0.3/win32/ . I have created a database with sql statement as below
CREATE TABLE my_table
(
"...
Hi.. I am setting up a VPS, and am having some issues with PostGres and php..
I get this:
Fatal error: Call to undefined function: pg_connect() in
I have installed PostGres.
I have u...
Hi!
We have a problem with Geoserver, PostGIS and MapBuilder.
Our map displays fine, but we noticed a lot of instances of postgres.exe in the task manager, simultaneously, mapbuilder f...
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...
