save to another database

From: First Last <y2kdis(at)atenista(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: save to another database
Date: 2006-01-20 06:07:38
Message-ID: 20060119220738.E662EB4D@dm22.mta.everyone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

how do i save the result of a query into a new table in another database? the IN database doesn't seem to work for in postgresql;
"SELECT * INTO newtable IN newdatabase FROM mytable";

_____________________________________________________________
Check out Atenista.Net (www.atenista.net)- new design, regular content and additional services!

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message A. Kretschmer 2006-01-20 06:20:00 Re: save to another database
Previous Message Tim Daly 2006-01-20 05:21:09 Curious date problem