[SQL] Database backup

[sreejith s]

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?

   http://archives.postgresql.org

[SQL] Postgres Doubt

[sreejith s]

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 for creating query, an error poping up. How to
create Query using 'pgsql' language. if any new tools need to be
installed. Plz rectify. Mail me back at [EMAIL PROTECTED]

Sreejith

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

[SQL] Database Backup

[sreejith s]

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. Then ho w to call pl/pgsql function from VB/.NET.
Sreejith

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] Record Count

[sreejith s]

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] Doubt :- Image_Insert

[sreejith s]

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: don't forget to increase your free space map settings

[SQL] Image Insert Postgresql DB

[sreejith s]

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 attched to the client machine and
these images r to be inserted into postgres db. Data type for Image
field in the DB is OID.
copy of Image file actually resides in the client. V have to insert
this image into the DB.

Query to insert

INSERT INTO Imagetable VALUES (lo_import('C:\\image\\peach.jpg')); 

here the path specified is the image path at client. But its doesn't
work. Since it is not
possible set the querys path to a remote machine.

How i can insert the image into the DB at linux machine where the
image file resides in the client machine.
pls reply

Sreejith

---(end of broadcast)---
TIP 8: explain analyze is your friend

[SQL] Image Insert Doubt

[sreejith s]

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 backup
both DB and Image folder. From Windows application how i can access a
folder in Linux and save my image data there. I have configured a
folder via Samba Server.
Its asking user name password when i first access the folder. Is it
can be avoided. My Second doubt is I want dump DB from my windows
client application, 'pg_dump' command with additional parameters not
working. but its working from server. how is this possible.
Sreejith

---(end of broadcast)---
TIP 8: explain analyze is your friend

[SQL] Crystal Report + Bytea field

[sreejith s]

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 your free space map settings

[SQL] Row Count

[sreejith s]

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] "Money" Data Type Problem

[sreejith s]

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 config files. Pls forward me the reply.

Sreejith

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly