Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: how to load database from extern files?
- From: Tino Wildenhain <tino(at)wildenhain(dot)de>
- To: caoyu(at)comp(dot)nus(dot)edu(dot)sg
- Cc: pgadmin-support(at)postgresql(dot)org
- Subject: Re: how to load database from extern files?
- Date: Tue, 24 Jan 2006 07:56:18 +0100
caoyu schrieb:
Use the pgAdmin III interface, I am using postgresql 8.1.2 on Windows. Thanks all
Well the easiest part would be to follow the documentation on postgresql.org using the command line pg_restore (for binary dumps) and psql if you have schema and/or data SQL. Recent pgadmin3 might have an interface for restoring, but the menu and accompanying documentation should tell you. The keyword to look for is restore, not "load". If all you want is to import tabular data, you might also have a look at SQL COPY which works from server backend or thru supporting tools. HTH Tino Wildenhain
- References:
- how to load database from extern files?
- From: caoyu
- how to load database from extern files?
- Prev by Date: how to load database from extern files?
- Next by Date: UPDATE on Pgadmin III not honoring DATESTYLE
- Previous by thread: how to load database from extern files?
- Next by thread: UPDATE on Pgadmin III not honoring DATESTYLE
- Indexes: