From: Papp Gyozo <pgerzson@freestart.hu>
To: David C. Brown <dbrown@centennialwines.com>
Cc: pgsql-php@postgresql.org
Subject: Re: Retrieving a list of tables
Date: Thu, 18 Oct 2001 12:43:54 +0200
Message-ID: <001401c157c2$0898fb40$01fdfea9@jaguar> (raw)
References: <Pine.LNX.4.30.0110171654070.13484-100000@hindang.msuiit.edu.ph>
If you runs psql with -E option, then psql reveals the SQL equivalent of its
magical metacommands starting with a backslash ie.: \dv \d and so on. Use
those queries !
<manual src="app-psql.html">
-E, --echo-hidden
Echoes the actual queries generated by \d and other backslash commands. You
can use this if you wish to include similar functionality into your own
programs. This is equivalent to setting the variable ECHO_HIDDEN from within
psql.
</manual>
----- Original Message -----
From: <erle@hindang.msuiit.edu.ph>
To: "David C. Brown" <dbrown@centennialwines.com>
Cc: <pgsql-php@postgresql.org>
Sent: Wednesday, October 17, 2001 10:59 PM
Subject: Re: [PHP] Retrieving a list of tables
> On Tue, 16 Oct 2001, David C. Brown wrote:
>
> > Heyas,
> >
> > I need to be able to get a list of the tables from a postgresql from
> > php. I'm
> > porting a php-mysql website over to postgresql. I have a form that
> > populates
> > a <SELECT> statment with the tables in the db.
> >
> > In Mysql I just used the sql query "SHOW TABLES;" postgresql doesn't
> > support that sql statment, and pg-php doesn't like me sending a "\d" as
> > a
> > query.
> >
> > Anyone have any help, or ideas how I may be able to work around this?
> > or is there a query for pg-sql that I don't know about?
> >
> > Any and all help would be great... Thanx
> >
> > Dave
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>
> Hey ,....
>
>
> If you want to know the list of tables in a certain database,
> you can query the pg_table table.
>
> select * from pg_tables where tableowner = 'ME';
>
> Its not really a table but a view, it contains all the tables in a
> database where you connected including the system tables of postgres so be
> sure to filter your query.
>
> Let me know if this was what you need ....
>
>
> Erle Czar S. Mantos
> erle@hindang.msuiit.edu.ph
>
> ---------- MARTIANS LAIR ---------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: pgerzson@freestart.hu, dbrown@centennialwines.com
Subject: Re: Retrieving a list of tables
In-Reply-To: <001401c157c2$0898fb40$01fdfea9@jaguar>
References: <Pine.LNX.4.30.0110171654070.13484-100000@hindang.msuiit.edu.ph> <001401c157c2$0898fb40$01fdfea9@jaguar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox