Time for your 3rd Quarter Update! Are you in the running for the 6th Annual Expert Awards? Click the link to find out.

Third Quarter Hot Shots
 

Having problems asking a question? Have a general question about Experts Exchange? Let us know!

 
Time Tested PostgreSQL Solutions: 76 - 100 of 338
 
what is the best way to store image files (JPG, GIF, BMP) in a PostgreSQL database? in Oracle i used to store them in BLOB fields. what about PostgreSQL? BYTEA fields maybe? it's for a desk...
Hi Experts, I'm using Postgres 8.3 now and trying to use the command line createuser.exe to create a user.  Ideally, I would put the password on the command line so that I can automate the in...
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...
How to check the database name of postgres in my linux machine i need to take the backup for that i have to give dabase name i only know username and password ... this is the command :...
OS: Linux (Debian) I am new to Linux/postgresql. I am trying install dspace as per the instruction given at the following site : http://dspace.org/technology/system-docs/install.html ...
Problem : Sometimes the database shuts down unexpectedly with little warning. The logs show different procedure calls each time, some only selects but all ending in "LOG: received fast shutdow...
how can I limit the result of a query, so that e.g. only 100 rows are loaded maximum? needs to run on every database, so it needs to be standard sql.
I am trying to create a trigger in postgres to update a field of a newly inserted record with a value returned from a query of another table in the same database.  The function below is my att...
Hi Experts, I'm trying to get a silent install of postgres 8.3 working properly on XP (SP2).  I run the following command: MSIEXEC /i "postgresql-8.3-int.msi" /qb /log "c:\mydir\logfile.tx...
Hi Experts, Just wondering if there is a free ADO.NET driver for C# and one for C++ to interface with Postgres?  I'm using Visual Studio 2008. Thank you! Mike
Hi experts! Until now, all the database developments I implemented were done using M$ SQL Server. Very much interested by the open source solutions, I recently started to use MyQSL to devel...
I have simple table described below. How I should form INSERT statement if I want to put a content of a file into TEXT field? INSERT INTO foo( `path`, `content` ) VALUES( '/etc/motd', SOME_...
We are converting a data import application from Oracle to PostgreSQL and are having some issues with functionality in Oracle that's missing in PostgreSQL. In Oracle, we do the following si...
Hi, I would like to optimize postgres for the best possible performance for a single query. I am not going to use it in a multi-user environment, but performance of a single query is most imp...
Hi all       How to migrate data from Postgre to MS SQL Server 2000 on Windows 2000 /Advanced Server? Thnx rahool
Hi, i need to make an update statement that does something like: update table set col = value + (select sum(col) where type = 'sometype') where .....etc but there is trouble when the ...
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 have a table called 'matrix' in mysql.  I am subtracting 10 from a field called 'dollarsGained'.  To accomplish this, I will use the following code:  LOCK TABLES matrix WRITE;  UPDATE ma...
Is there a way to grant access to multiple tables at once?  I know how to create groups, but I have dozens of tables that need access by the developers (set up as a group) and read only access...
For some reason Posgresql won't start anymore. When I start PGAdmin I get the following message: Server doesn't listen The server doesn't accept connections: the connection library reports...
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...
I have a Ubuntu Server setup at a friends house and I want to be able to manage PostgreSQL from my house via pgAdmin III for Windows. I'm connected to the box though SSH and have port forwardi...
I am trying to write a function in postgresql and I keep getting the error: language "plpgsql" does not exist.  I have type in createlang cs442 and added 'Language plpgsql to my function but I...
Hi experts,     I am working on VS2005 and Back end is PostgreSql8.2.  Here i am using PostgreSQLDirect .NET Data Provider as the connectivity between VS and postgre.  I am not able to get th...
Hello, I'm new to postgres and I've googled on this seemingly simple issue all morning... FreeBSD 6.1 PostgreSQL 8.2.3 PHP 5.2.5 I want to query my table and return records (to scri...