Re: Change connection (IP, or Databasename)

Not sure what you are asking...  If you want to create
a copy of your production database for
development/testing purposes, the easiest way is:

CREATE DATABASE myseconddatabase WITH TEMPLATE
myfirstdatabase;

Then just create a new DSN pointing to the new
database (or change your code, if you are not using a
DSN).  You would need to relink your tables also.

--- "E. Zorn (RDG-rational)" <edv@rdg-rational.de>
wrote:
> hi,
> I am using Access as a front-end for postgresql via
> ODBC.
>
> The postgresql-server is hosted on a separate
> linux-computer.
>
> I like to change the database on the SQL-server for
> developing or
> change the IP of the connected SQL-server so that
> the original data wouldn�t
> be changed.
>
> Does anybody know a quick and comfortable way to do
> this. I know the
> possibility of importing the whole tables once again
> but they all have a
> header like "public_" which I have than manually to
> change.
>
> Elmar Zorn
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com