<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.2614.3500" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>We solved by using</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>pg_dump <FONT face=Arial size=2>-f tablas.sql
ejercicio</FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>and dumps everything</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Juanse</FONT></DIV>
<DIV><FONT face=Arial size=2>temuko-chile</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=ltr
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A href="mailto:chodgson@refractions.net" title=chodgson@refractions.net>Chris
Hodgson</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
href="mailto:postgis-users@postgis.refractions.net"
title=postgis-users@postgis.refractions.net>postgis-users@postgis.refractions.net</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, October 24, 2002 2:15
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [postgis-users] RV: How
export a postgreSQL/GIS</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Actually, I'm told that you won't get views
dumped if you use this method, whereas -t "*" dumps the views as
well.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Chris</FONT></DIV>
<BLOCKQUOTE dir=ltr
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A href="mailto:chodgson@refractions.net"
title=chodgson@refractions.net>Chris Hodgson</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
href="mailto:postgis-users@postgis.refractions.net"
title=postgis-users@postgis.refractions.net>postgis-users@postgis.refractions.net</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, October 24, 2002 10:05
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [postgis-users] RV: How
export a postgreSQL/GIS</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>At first, it doesn't seem possible to use
pg_dump to dump sequences - it says on the man page:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>"pg_dump will save the information necessary to
re-generate all user-defined types, functions, tables,
indexes, aggregates, and operators."</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>That seems to be a rather complete list that
doesn't contain "sequences" - in fact they aren't mentioned anywhere in
the doc.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>However, after more careful reading, sequences
aren't treated as special entities by postgres, they are just tables on
which the nextval, setval, etc. functions work. I guess because of their
status as "sequences", -t "*" doesn't include them. However, if you either
specify the name of the sequence specifically using -t seq_name or simply
leave out the -t parameter altogether, sequences do get dumped (as tables,
with setval() function calls afterward).</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>So try:</FONT></DIV>
<DIV><FONT face=Arial size=2>pg_dump -f tablas.sql ejercicio</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>And I think you will get everything
dumped.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Chris</FONT></DIV>
<BLOCKQUOTE dir=ltr
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A href="mailto:georef@tie.cl" title=georef@tie.cl>Juanse</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
href="mailto:postgis-users@postgis.refractions.net"
title=postgis-users@postgis.refractions.net>postgis-users@postgis.refractions.net</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, October 23, 2002
9:45 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [postgis-users] RV: How
export a postgreSQL/GIS</DIV>
<DIV><BR></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>I am trying to export a postgreSQL/postGIS
database to on other computer.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>we are doing a :</FONT></DIV>
<DIV><FONT face=Arial size=2>pg_dump -t "*" -f tablas.sql
ejercicio</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>to prepare the table to ftp it.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>how ever we get everything out except the
sequences on the new "tablas" database.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>what are we doing wrong? or better how we
should do it?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Juanse</FONT></DIV>
<DIV><FONT face=Arial size=2>temuko-chile</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><BR>---<BR>Outgoing mail is certified Virus
Free.<BR>Checked by AVG anti-virus system (<A
href="http://www.grisoft.com">http://www.grisoft.com</A>).<BR>Version:
6.0.401 / Virus Database: 226 - Release Date: 10/10/02</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><BR>---<BR>Outgoing mail is certified Virus
Free.<BR>Checked by AVG anti-virus system (<A
href="http://www.grisoft.com">http://www.grisoft.com</A>).<BR>Version:
6.0.401 / Virus Database: 226 - Release Date:
09/10/02</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>