I am trying to move some of my databases from our older 6.3.1 database
server, to our newer and faster server running 6.3.2 (all under linux).
Basically I am attempting to do:
pg_dump database > /tmp/database.data
then on the new machine
createdb database
psql -f /tmp/database.data database
I
I am in charge of software development in our company. We are currently researching
having contractor(s) develop business applications (client/server and Web enabled)
using both Linux and PostgreSQL. We are located in Ann Arbor, Michigan and are looking
for a partner company geographically clos
On Fri, 22 Jan 1999, Martin Wong wrote:
# it seems to work fine but it is an extra overhead when it creates a tmp
# file. How can this be cached? Or can it be directed directly to the web
# page instead of having to go through another step of createing a temp
# file.
Your application sh
This will return all columns including the OID:
select oid,* from my_table
To index the OID column:
create index my_table_oid on my_table( oid )
Other tables can reference the OID column:
create table another_table (
...
my_table_refoid
Dan Warren ha scritto:
> You'll have to forgive me if this is a trivial question but I'm *very*
> new to this. I'm developing an online time clock program and was
> wondering if there was a character based front end, similar to Oracle's
> SQL*Forms, that could be used for a postgres 6.4.2 data
Hi,
You can use the lo_open() - lo_read() - lo_write() - lo_seek() C like functions
that allow to read, write and more directly into your blobs and so display data
on the fly...
This is already in the documentation - PostgreSQL Programmer's Guide - Chapter
15. Large Objects.
Martin Wong wrote:
Hello
Sorry my silly question, but I can't quite undestand what is OID for ?
More cleary, I can't undestand a way of using OID.
Can sombody give me some examples of using OIDs ? How can I get OID of
tables and how use table's OID in SQL-request.
I would appreciate any response,
Dear all,
I have a pgsql database table packed with images and another one packed with
text files, all blobs. I have a script in perl which first extracts the
images/text via the lo_export into a temp directory on my server and then
it'll display the contents of the file on an HTML page passing H
