From: | "Duncan Adams (DNS)" <duncan(dot)adams(at)vcontractor(dot)co(dot)za> |
---|---|
To: | pgsql-php(at)postgresql(dot)org |
Subject: | Re: Retrieving a list of tables |
Date: | 2001-10-24 09:33:16 |
Message-ID: | C54EF5B83335D311BCB50000C11042B102C8C6C9@vodabemail1.vodacom.co.za |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
select * from pg_tables where name not like 'pg_%';
\dS gives you a list of system tables.
with psql -E
\dt gives you
SELECT c.relname as "Name", 'table'::text as "Type", u.usename as "Owner"
FROM pg_class c, pg_user u
WHERE c.relowner = u.usesysid AND c.relkind = 'r'
AND not exists (select 1 from pg_views where viewname = c.relname)
AND c.relname !~ '^pg_'
UNION
SELECT c.relname as "Name", 'table'::text as "Type", NULL as "Owner"
FROM pg_class c
WHERE c.relkind = 'r'
AND not exists (select 1 from pg_views where viewname = c.relname)
AND not exists (select 1 from pg_user where usesysid = c.relowner)
AND c.relname !~ '^pg_'
ORDER BY "Name"
-----Original Message-----
From: David C. Brown [mailto:dbrown(at)centennialwines(dot)com]
Sent: Tuesday, October 16, 2001 10:09 PM
To: pgsql-php(at)postgresql(dot)org
Subject: [PHP] Retrieving a list of tables
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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
From | Date | Subject | |
---|---|---|---|
Next Message | Mo Holkar | 2001-10-24 16:54:18 | Security |
Previous Message | Papp Gyozo | 2001-10-22 15:59:03 | Re: how to get the field types of a(n empty) table? |