lo_import

Started by Bob Pawleyover 19 years ago6 messagesgeneral

rjpawley@shaw.ca

over 19 years ago

My remote server recognizes the fokkowing expression as a server side command.

-----
Insert Into library.devices (Item_id, device, a_d, designation, function_, type_, function1)
Values ( 'Tdeviceft2a', lo_import('c:/program files/postgresql/8.0/lib/images/magflow.bmp'), 'a', 'F', 'A_Flow', 'mon', 'Flow') ;

---

Various documents, including PostgreSQL, suggest modifications such as - \lo_import, lo_import(), oid lo_import - to make the statement work on the client side.

I can't make them work. What am I missing?

Insert Into library.devices (Item_id, device, a_d, designation, function_, type_, function1)
Values ( 'Tdeviceft2a', \lo_import ('c:/program files/postgresql/8.0/lib/images/magflow.bmp'), 'a', 'F', 'A_Flow', 'mon', 'Flow') ;

Bob Pawley

Joshua D. Drake

jd@commandprompt.com

over 19 years ago

In reply to: Bob Pawley (#1)

Re: lo_import

On Fri, 2006-12-22 at 10:05 -0800, Bob Pawley wrote:

My remote server recognizes the fokkowing expression as a server side
command.

-----
Insert Into library.devices (Item_id, device, a_d, designation,
function_, type_, function1)
Values ( 'Tdeviceft2a', lo_import('c:/program
files/postgresql/8.0/lib/images/magflow.bmp'), 'a', 'F', 'A_Flow',
'mon', 'Flow') ;

If what you are asking is how can I use lo_import from a remote client,
you can't, unless the file you are importing is on the server.

Joshua D. Drake

---

Various documents, including PostgreSQL, suggest modifications such as
- \lo_import, lo_import(), oid lo_import - to make the statement work
on the client side.

I can't make them work. What am I missing?

Insert Into library.devices (Item_id, device, a_d, designation,
function_, type_, function1)
Values ( 'Tdeviceft2a', \lo_import ('c:/program
files/postgresql/8.0/lib/images/magflow.bmp'), 'a', 'F', 'A_Flow',
'mon', 'Flow') ;

Bob Pawley

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

Bob Pawley

rjpawley@shaw.ca

over 19 years ago

In reply to: Bob Pawley (#1)

Re: lo_import

If I can't use lo_import what method do you suggest I use for a large object
(in this case images).

Bob

----- Original Message -----
From: "Joshua D. Drake" <jd@commandprompt.com>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Postgresql" <pgsql-general@postgresql.org>
Sent: Friday, December 22, 2006 10:12 AM
Subject: Re: [GENERAL] lo_import

Show quoted text

On Fri, 2006-12-22 at 10:05 -0800, Bob Pawley wrote:

My remote server recognizes the fokkowing expression as a server side
command.

-----
Insert Into library.devices (Item_id, device, a_d, designation,
function_, type_, function1)
Values ( 'Tdeviceft2a', lo_import('c:/program
files/postgresql/8.0/lib/images/magflow.bmp'), 'a', 'F', 'A_Flow',
'mon', 'Flow') ;

If what you are asking is how can I use lo_import from a remote client,
you can't, unless the file you are importing is on the server.

Joshua D. Drake

---

Various documents, including PostgreSQL, suggest modifications such as
- \lo_import, lo_import(), oid lo_import - to make the statement work
on the client side.

I can't make them work. What am I missing?

Insert Into library.devices (Item_id, device, a_d, designation,
function_, type_, function1)
Values ( 'Tdeviceft2a', \lo_import ('c:/program
files/postgresql/8.0/lib/images/magflow.bmp'), 'a', 'F', 'A_Flow',
'mon', 'Flow') ;

Bob Pawley

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

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

Joshua D. Drake

jd@commandprompt.com

over 19 years ago

In reply to: Bob Pawley (#3)

Re: lo_import

On Fri, 2006-12-22 at 10:25 -0800, Bob Pawley wrote:

If I can't use lo_import what method do you suggest I use for a large object
(in this case images).

It would be helpful if I knew what you were actually trying to do. For
example, perl has the ability to remotely do lo manipulation.

Joshua D. Drake

Bob

----- Original Message -----
From: "Joshua D. Drake" <jd@commandprompt.com>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Postgresql" <pgsql-general@postgresql.org>
Sent: Friday, December 22, 2006 10:12 AM
Subject: Re: [GENERAL] lo_import

On Fri, 2006-12-22 at 10:05 -0800, Bob Pawley wrote:

My remote server recognizes the fokkowing expression as a server side
command.

-----
Insert Into library.devices (Item_id, device, a_d, designation,
function_, type_, function1)
Values ( 'Tdeviceft2a', lo_import('c:/program
files/postgresql/8.0/lib/images/magflow.bmp'), 'a', 'F', 'A_Flow',
'mon', 'Flow') ;

If what you are asking is how can I use lo_import from a remote client,
you can't, unless the file you are importing is on the server.

Joshua D. Drake

---

Various documents, including PostgreSQL, suggest modifications such as
- \lo_import, lo_import(), oid lo_import - to make the statement work
on the client side.

I can't make them work. What am I missing?

Insert Into library.devices (Item_id, device, a_d, designation,
function_, type_, function1)
Values ( 'Tdeviceft2a', \lo_import ('c:/program
files/postgresql/8.0/lib/images/magflow.bmp'), 'a', 'F', 'A_Flow',
'mon', 'Flow') ;

Bob Pawley

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

Bob Pawley

rjpawley@shaw.ca

over 19 years ago

In reply to: Bob Pawley (#1)

Re: lo_import

I have an interface that I am attempting to connect to a remote database for
which I have only client privileges. ( I would prefer to incorporate all of
this in a single installable .exe file, as the application, as it now
stands, is for mostly single users. But the only method I have found to do
this is to rebuild the database as part of the installataion. Rather than
rebuild, which I think is inefficient, I am looking into building the
database as a remote server.)

Part of the database is an image file using lo_import, which works well on
localhost.

Bob

Show quoted text

On Fri, 2006-12-22 at 10:25 -0800, Bob Pawley wrote:

If I can't use lo_import what method do you suggest I use for a large
object
(in this case images).

It would be helpful if I knew what you were actually trying to do. For
example, perl has the ability to remotely do lo manipulation.

Joshua D. Drake

Bob

----- Original Message -----
From: "Joshua D. Drake" <jd@commandprompt.com>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Postgresql" <pgsql-general@postgresql.org>
Sent: Friday, December 22, 2006 10:12 AM
Subject: Re: [GENERAL] lo_import

On Fri, 2006-12-22 at 10:05 -0800, Bob Pawley wrote:

My remote server recognizes the fokkowing expression as a server side
command.

-----
Insert Into library.devices (Item_id, device, a_d, designation,
function_, type_, function1)
Values ( 'Tdeviceft2a', lo_import('c:/program
files/postgresql/8.0/lib/images/magflow.bmp'), 'a', 'F', 'A_Flow',
'mon', 'Flow') ;

If what you are asking is how can I use lo_import from a remote client,
you can't, unless the file you are importing is on the server.

Joshua D. Drake

---

Various documents, including PostgreSQL, suggest modifications such as
- \lo_import, lo_import(), oid lo_import - to make the statement work
on the client side.

I can't make them work. What am I missing?

Insert Into library.devices (Item_id, device, a_d, designation,
function_, type_, function1)
Values ( 'Tdeviceft2a', \lo_import ('c:/program
files/postgresql/8.0/lib/images/magflow.bmp'), 'a', 'F', 'A_Flow',
'mon', 'Flow') ;

Bob Pawley

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project:
http://www.postgresql.org/about/donate

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

Joshua D. Drake

jd@commandprompt.com

over 19 years ago

In reply to: Bob Pawley (#5)

Re: lo_import

On Fri, 2006-12-22 at 10:58 -0800, Bob Pawley wrote:

I have an interface that I am attempting to connect to a remote database for
which I have only client privileges. ( I would prefer to incorporate all of
this in a single installable .exe file, as the application, as it now
stands, is for mostly single users. But the only method I have found to do
this is to rebuild the database as part of the installataion. Rather than
rebuild, which I think is inefficient, I am looking into building the
database as a remote server.)

Part of the database is an image file using lo_import, which works well on
localhost.

If it is just images, consider bytea.

Joshua D. Drake

Bob

----- Original Message -----
From: "Joshua D. Drake" <jd@commandprompt.com>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Postgresql" <pgsql-general@postgresql.org>
Sent: Friday, December 22, 2006 10:32 AM
Subject: Re: [GENERAL] lo_import

On Fri, 2006-12-22 at 10:25 -0800, Bob Pawley wrote:

If I can't use lo_import what method do you suggest I use for a large
object
(in this case images).

It would be helpful if I knew what you were actually trying to do. For
example, perl has the ability to remotely do lo manipulation.

Joshua D. Drake

Bob

----- Original Message -----
From: "Joshua D. Drake" <jd@commandprompt.com>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Postgresql" <pgsql-general@postgresql.org>
Sent: Friday, December 22, 2006 10:12 AM
Subject: Re: [GENERAL] lo_import

On Fri, 2006-12-22 at 10:05 -0800, Bob Pawley wrote:

My remote server recognizes the fokkowing expression as a server side
command.

-----
Insert Into library.devices (Item_id, device, a_d, designation,
function_, type_, function1)
Values ( 'Tdeviceft2a', lo_import('c:/program
files/postgresql/8.0/lib/images/magflow.bmp'), 'a', 'F', 'A_Flow',
'mon', 'Flow') ;

If what you are asking is how can I use lo_import from a remote client,
you can't, unless the file you are importing is on the server.

Joshua D. Drake

---

Various documents, including PostgreSQL, suggest modifications such as
- \lo_import, lo_import(), oid lo_import - to make the statement work
on the client side.

I can't make them work. What am I missing?

Insert Into library.devices (Item_id, device, a_d, designation,
function_, type_, function1)
Values ( 'Tdeviceft2a', \lo_import ('c:/program
files/postgresql/8.0/lib/images/magflow.bmp'), 'a', 'F', 'A_Flow',
'mon', 'Flow') ;

Bob Pawley

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project:
http://www.postgresql.org/about/donate

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate