Обсуждение: how to load database from extern files?

Поиск
Список
Период
Сортировка

how to load database from extern files?

От
"caoyu"
Дата:
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Use the pgAdmin III interface, I am using postgresql 8.1.2 on Windows.</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">Thanks all</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Yu</span></font></div>

Re: how to load database from extern files?

От
Tino Wildenhain
Дата:
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