Re: [ADMIN] Validade dump file

2010-10-05 Thread Kevin Grittner
Willy-Bas Loos wrote: > any idea for the number of tuples? Your best bet would be to use whatever scripting language you like which has decent support for regular expressions. Expect to tweak your expressions a bit as you discover the corner cases where you're not getting the count you expect

Re: [ADMIN] Validade dump file

2010-10-05 Thread Willy-Bas Loos
cool actually. any idea for the number of tuples? count all lines after COPY .* ) FROM stdin; until \. (but how?) on a side note: what's the difference between the admin list and the general list? -- "Patriotism is the conviction that your country is superior to all others because you were born

Re: [ADMIN] Validade dump file

2010-10-04 Thread Guillaume Lelarge
Le 05/10/2010 05:28, Fábio Gibon - Comex System a écrit : > [...] > are there some tool or internal program that read a dump file (created by > pg_dump) and list all tables and number of tuples (without > restore) in this file? > That command should give you the number of tables in your plain d

[ADMIN] Validade dump file

2010-10-04 Thread Fábio Gibon - Comex System
Hi everybody, are there some tool or internal program that read a dump file (created by pg_dump) and list all tables and number of tuples (without restore) in this file? And too, are there some tool to check the physical file integrity? (S.O. Windows) thanks Fábio Henrique Gib