Postgres Pro
Downloads
Home   >   mailing lists

save to another database - Mailing list pgsql-novice

From First Last
Subject save to another database
Date
Msg-id 20060119220738.E662EB4D@dm22.mta.everyone.net
Whole thread Raw
Responses Re: save to another database  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-novice
Tree view 
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!

pgsql-novice by date:

Previous
From: Tim Daly
Date:
Subject: Curious date problem
Next
From: "A. Kretschmer"
Date:
Subject: Re: save to another database