2008/12/12 Lucas Paz <[email protected]>: > qual comando daria conta? > > 2008/12/12 Fábio Telles Rodriguez <[email protected]> >> >> 2008/12/12 Lucas Paz <[email protected]>: >> > Opa só uso linux :P ... >> > >> >> Gente... para criar um script quando um único comando SQL dá conta? >>
Ok, ok... você não olhou os links que eu te passei, olhou? >> []s >> >> >> > >> > >> > 2008/12/12 joao junior <[email protected]> >> >> >> >> vc tem linux em maos? :) >> >> se tiver te mando um shell script :P >> >> >> >> On Fri, 2008-12-12 at 10:49 -0200, Fábio Telles Rodriguez wrote: >> >> > 2008/12/12 Lucas Paz <[email protected]>: >> >> > > Bom dia pessoal, >> >> > > >> >> > > Preciso de mais 1 ajuda, tenho 1 banco de dados com mais de 1000 >> >> > > tabelas >> >> > > (1039 pra ser exato) e preciso alterar o dono do banco e de todas >> >> > > as >> >> > > tabelas... tem alguma maneira prática de fazer isso sem fazer o >> >> > > dump >> >> > > do >> >> > > banco? >> >> > >> >> > Claro, você vai precisar de: >> >> > >> >> > http://www.postgresql.org/docs/8.3/static/sql-altertable.html >> >> > >> >> > e também de: >> >> > http://www.postgresql.org/docs/8.3/static/infoschema-tables.html >> >> > >> >> > Com isso você deve chegar lá! >> >> > >> >> > []s >> >> > Fábio Telles >> >> >> >> _______________________________________________ >> >> pgbr-geral mailing list >> >> [email protected] >> >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> > >> > >> > >> > -- >> > Lucas Paz >> > >> > >> > _______________________________________________ >> > pgbr-geral mailing list >> > [email protected] >> > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> > >> > >> >> >> >> -- >> blog: http://www.midstorm.org/~telles/ >> e-mail / jabber: [email protected] >> _______________________________________________ >> pgbr-geral mailing list >> [email protected] >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > > > -- > Lucas Paz > > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > -- blog: http://www.midstorm.org/~telles/ e-mail / jabber: [email protected] _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
