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?
Databases

Avatar of undefined
Last Comment
Bill Bach

8/22/2022 - Mon
Mirtheil

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/).
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
Mirtheil

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Bill Bach

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.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck