hehehehe ta aí a resposta tosca tb hehehee
QUERY="select relname from pg_class inner join pg_namespace
on(pg_class.relnamespace=pg_namespace.oid) where
pg_namespace.nspname='public' and relkind='r'"
psql -U postgres -h hostname -t -c "$QUERY" banco | grep -v "^$"| while
read linha
do
pg_dump -U postgres -a -d -h localhost -t $linha banco | grep -i
insert | head -n 10 >> saida.sql
done
----- Original Message -----
From: "Fernando Ike de Oliveira" <[EMAIL PROTECTED]>
To: "Comunidade PostgreSQL Brasileira" <[email protected]>
Sent: Friday, July 06, 2007 4:08 PM
Subject: [pgbr-geral] backup dos primeiros registros
Olá lista,
Um probleminha, com o pg_dump não consigo fazer um backup de base
dos primeiros 10 registros de cada tabela? (pergunta tosca) =/
[]'s
--
Fernando Ike
http://www.midstorm.org/~fike/weblog
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
