[SQL] "Money" Data Type Problem

Hai friends, I have a field with data type 'Money' with my table. I select this field a select query and displays the same in a textbox. While doing this a dollar ($) is prefixed to the actual table value. How to avoid this symbol so as to display the actual value only. Any format change needed in

[SQL] Row Count

Hai friends, How get Row count in a plpgsql fuction after executing update or delete query to determine no. of rows affected. Sreejith ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] Crystal Report + Bytea field

Hai friends, I stored image in binay format at a field with type bytea. Now i have to display the image(Stored in the bytea field) in a crystal report. is this possible. How? Pls Reply Sreejith ---(end of broadcast)--- TIP 7: don't forget to increase

[SQL] Image Insert Doubt

Dear Vishal, I have posted a doubt regarding image insert into Postgres. Thanx for ur valuable information. I am new to Postgres/Linux Environment. Intially i thought it would be better to store image path into DB. Later i changed my idea. Since it will be difficult/Tedious to bac

[SQL] Image Insert Postgresql DB

Hello I have a doubt regarding Image insert into Postgres DB. Yesterday i posted a query regarding this. and this one is in continuation. I am working on Project with Linux Server and Windows Client environment. And v r developing windows based application. V have to scan images from scanner attche

[SQL] Doubt :- Image_Insert

Hello friends I have a doubt, Is it possible to insert images into a postgres db. What is its datatype. Is its possible to insert jpeg images. or v have to store the path into the db. Pls reply. its urgent. Sreejith ---(end of broadcast)--- TIP 7: d

[SQL] Database backup

Hai, How to take Database backup from an application developed in Visual Basic thats running at Windows Client and Database resting at Linux Server. THanx Sreejith ---(end of broadcast)--- TIP 6: Have you searched our list archives?

[SQL] Record Count

Friends, How to get a the records returned by a sql executed within a pl/pgsql function Sreejith ---(end of broadcast)--- TIP 8: explain analyze is your friend

[SQL] Database Backup

Hello, Now i am working on Linux database server/Windows Client project. I have a doubbt. How to take DB backup from my windows client machine where DB is intsalled at linux server. pg_dump doen't works from windows client butr its working from local server machine. How to rectify the problem.

[SQL] Postgres Doubt

Hello, I am new to PostgreSQL. I have a doubt. Now i am doing one project in .NET technology with postgres(linux) as database. I am using pgADMIN and pgManager as tools for database releted activities. Now i am able to create functions with 'sql' language. When i select 'pgsql' as language fo