Link to home
Start Free TrialLog in
Avatar of directred
directred

asked on

How can I get a screen dump of my Pervasive Database

I wonder if anyone can help me.

How can you get list of all tables, fields in tables etc from a Pervasive Database without going into each individual table. Is there any commands out there that do this. If not any suggestions?
Avatar of Mirtheil
Mirtheil
Flag of United States of America image

What version of PSQL are you using?  In PSQL v9, there are system stored procedures that you can run.. Look at psp_columns and psp_tables.  
If that doesn't help, you might need to look at a third party tool like DDF Printer (http://www.mirtheil.com/ddfprinter.asp) or BTSearch32 (http://www.nssdd.com/).
Avatar of directred
directred

ASKER

Thanks for the reply.

I am using version 9.

I tried psp_ and they work to an extent and will be very useful to me but what I need is something to print the whole database with tables and columns within the tables.

I do not think it can be done.

Postgres use something like pg_dump and pg_dumpall.

ASKER CERTIFIED SOLUTION
Avatar of Mirtheil
Mirtheil
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If you call the psp_* functions from the Pervasive Control Center and run the query to the TEXT window (instead of the grid), then you can easily print the results.  Right-click the text window and select Select All.  Then, right-click it again and select Copy.  Start WordPad or your favorite text editor and Paste the results there.  Format & print out, if needed.

Another option is the FPrint tool from Goldstar Software (http://www.goldstarsoftware.com/download.asp).  This tool can print the definitions from a command line to the screen or to a printer via redirection.  The older DOS version is a free tool, but it will probably work just fine.  There is a newer Win32 version ($50) that supports some of the newer features in the newer PSQL engines (including the newer PSQLv9 data types) if you wanted to go that route, too.