Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    4

    Question Unanswered: insert into a remote table

    Hi,

    I am trying do this:

    insert into db1.table1
    select * from db2.table1;

    Is this working for PostgreSQL?

    How can i do it?

    danielal

  2. #2
    Join Date
    Oct 2003
    Posts
    12

  3. #3
    Join Date
    Sep 2003
    Posts
    4
    It works for 'select', but it doesn't work for insert.

    thanks.

  4. #4
    Join Date
    Oct 2003
    Posts
    12
    I blv urs current connection is db1 thus u don't need refrenece to db1

    insert into table select * from db2.table

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •