Re: [GENERAL] How to find names of tables in a database?

1998-10-14 Thread Simon Drabble
On Wed, 14 Oct 1998, Valerie Mates wrote: > Hi -- I've been dabbling in PostgreSQL on and off for a few months now. At > this point I can get it to do a number of neat things, but I've run into > one that is a stumper. > > I'm looking for a way that my Perl program can look up the names of the

Re: [GENERAL] How to find names of tables in a database?

1998-10-14 Thread Valerie Mates
At 07:43 PM 10/14/98 -0400, Bruce Momjian wrote: >> I thought for sure this was on the FAQ... >> What you are looking for is the behavior of psql's \dt command. >> You can look at the psql source to get the exact query, but it's >> something like this: >> SELECT * FROM pg_class >> The \dt com

Re: [GENERAL] How to find names of tables in a database?

1998-10-14 Thread Bruce Momjian
> I thought for sure this was on the FAQ... > What you are looking for is the behavior of psql's \dt command. > You can look at the psql source to get the exact query, but it's > something like this: > SELECT * FROM pg_class > The \dt command filters out the system (WHERE rel_name NOT LIKE '

Re: [GENERAL] How to find names of tables in a database?

1998-10-14 Thread Gene Selkov Jr.
"Jackson, DeJuan" wrote: > > I'm looking for a way that my Perl program can look up the names of > > the > > tables in a database. Is there a way to do this? > > I thought for sure this was on the FAQ... Maybe it isn't yet, but it is in "Administrative Tasks" chapter of the users's manual (alo

RE: [GENERAL] How to find names of tables in a database?

1998-10-14 Thread Jackson, DeJuan
> Hi -- I've been dabbling in PostgreSQL on and off for a few months > now. At > this point I can get it to do a number of neat things, but I've run > into > one that is a stumper. > > I'm looking for a way that my Perl program can look up the names of > the > tables in a database. Is there a w

[GENERAL] Re:

1998-10-14 Thread La Mancha de la Calabaza que Ladra
>This is an pgsql's old bug already reported by me. >The problem is that you can't reproduce this behavior all the time. >I have this bug also, but it appears only sometimes. It isn't danger >only disquieting. ;-) Yes, it doesn't interferes with my sleeping, but as that particular table is growi

[GENERAL] How to find names of tables in a database?

1998-10-14 Thread Valerie Mates
Hi -- I've been dabbling in PostgreSQL on and off for a few months now. At this point I can get it to do a number of neat things, but I've run into one that is a stumper. I'm looking for a way that my Perl program can look up the names of the tables in a database. Is there a way to do this? I'

[GENERAL] Suggestions for pg_hba.conf contents needed for dynamic IP

1998-10-14 Thread Gilley, Charles H.
I'm trying to establish a robust yet inexpensive method of updating an online database (hopefully postgres) via a customer's database (Access). The goal is to update the online database nightly via an ODBC connection. My problem is that the customer's web site is on a virtual host, so I don't rul