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?
directredAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MirtheilSoftware DeveloperCommented:
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/).
directredAuthor Commented:
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.

MirtheilSoftware DeveloperCommented:
There's nothing like pg_dump in Pervasive. You could string the psp_* together to get all of the tables but if you need it all together without stringing multiple calls together, you're going to want to look at the third party tools.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bill BachPresident and Btrieve GuruCommented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.