by: Clive Page |
last post by:
What I'd like to do is use dblink to extract a few rows from a remote
database and manipulate these within a function in pl/pgsql. Something
like this:
CREATE OR REPLACE FUNCTION find() RETURNS...
|
by: Brian Maguire |
last post by:
What's the best way to create a connection with dblink with persisted
connections for web applications?
For example:
I want to have a view that links to a table in another pg database so I...
|
by: Oleg Lebedev |
last post by:
Is there a way to rollback a dblink transaction?
Say, I delete some data from the remote database, but I don't want this
to be visible untill the data is inserted in the current database. And
if...
|
by: Mark Gibson |
last post by:
Hello,
I've been experimenting with dblink recently, and have encountered some
limitations I'd like to discuss.
I've been trying to create views of remote tables, like so:
CREATE VIEW stuff...
|
by: Sam Masiello |
last post by:
Hello all!
I am rather stuck and am hoping someone can help. I am working on a
project where users need to be able to send one query which will hit
databases on multiple hosts (the database...
|
by: Kreißl, Karsten |
last post by:
Hello,
we want use dblink to connect several databases in a client/server environment. Connection from local users to the remote databases should be possible only for privileged users. We tried a...
|
by: Jim Worke |
last post by:
Hi list,
My boss would like to convert from MySQL to PostgreSQL, but there are a few
things that hold us back.
We'd like to have the databases in several physical servers, with referential...
|
by: priyapatil |
last post by:
hello everyone
i want to use dblink functions to access a remote database
bt i am not able to install those functions on my machine
i am using postgresql 8.2 on windows XP machine
can anyone...
|
by: stephcsh |
last post by:
Hi, I wanted to copy a data from table1 in db1 to table2 in db2, which has the same structure, with the PosgreSQL dblink funtion.
The fields for both the tables are: id, first_name, last_name.
...
|
by: dsslim |
last post by:
Hi,
Oracle instance A has a dblink to DB2 DB. Oracle instance B, which resides on the another machine wants to access the DB2 via Oracle instance A's dblink.
Possible ?
TIA !
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|