In article <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]> writes:
> Hi all,
>
> I going to cahge machine, but I need to make backup of my database, my
> version of postgresql is: 6.5.3 now my version will be 7.0.
>
> How can I to make the backup of tables, index and data?
>
> Thanks in advanc
pg_dump -Dn databasename > mybackupdatabasename.sql
to restore:
create databasename_new
psql -e databasename_new < mybackupdatabasename_new.sql
more information man pg_dump
regards
On Fri, 2 Feb 2001 [EMAIL PROTECTED] wrote:
{Hi all,
{
{I going to cahge machine, but I need to make backup o
Hi all,
I going to cahge machine, but I need to make backup of my database, my
version of postgresql is: 6.5.3 now my version will be 7.0.
How can I to make the backup of tables, index and data?
Thanks in advanced.
--
\/_\_
Saludos,
"La Vida"
> HOla a todos, quisiera remitirles una par de consultas
> 1. Como realizo una funcion que me retorne una
> consulta o tablas temporales
Podes usar \"select into\", para mas info mira esta
pagina:
http://www.postgresql.org/users-lounge/docs/7.0/user/sql-selectinto.htm
Rodrigo F.
--
HOla a todos, quisiera remitirles una par de consultas
1. Como realizo una funcion que me retorne una
consulta o tablas temporales
_
Do You Yahoo!?
Obtenga su dirección de correo-e gratis @yahoo.com
en http://correo.espanol.yahoo.com
