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...
