Re: Getting a list of tables in a database with Perl
| От | Andrew Magnus |
|---|---|
| Тема | Re: Getting a list of tables in a database with Perl |
| Дата | |
| Msg-id | 20021120002332.9821.qmail@web21505.mail.yahoo.com обсуждение исходный текст |
| Ответ на | Getting a list of tables in a database with Perl (Andrew Magnus <xanadian99@yahoo.com>) |
| Список | pgsql-general |
I am, actually, using DBI. I'm using Postgres on Linux with Perl 5.8.
What I'm trying to do is this: the script checks to see if a table exists in the database, and if it doesn't, it creates it. It then carries the name of the table in a $variable for use with inserting, etc. That's it.
Thanks.
--andrew:
--are you looking for just a list of tables, or, are you trying
--to do something with the tables (insert / update / copy / etc)?
--also, what database are you using and on what platform?
--you may end up installing and using a DBI::DBD module.
--i am running PostgreSQL on a Linux platform ... if i can help,
--just post again and i'll submit the few examples i have.
--laters!
-X
-----Original Message-----I would like to know how I can fetch a list of existing tables in a database within a Perl script. Could someone please tell me how this can be done, or, at least, a good reference to look it up? Thanks.
From: Andrew Magnus [mailto:xanadian99@yahoo.com]
Sent: Tuesday, November 19, 2002 4:53 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Getting a list of tables in a database with Perl
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
В списке pgsql-general по дате отправления: