As a PostgreSQL admin or developer, you may be asked to deploy a Linux
Apache PHP PostgreSQL application. As you know, and simplifying things
a great deal here, the pg_hba.conf file can be edited in approximately
7 different ways:
* locked down -- no access at all (usually the default)
* trust
Using PHP and PostgreSQL only, what do you feel are the most popular
CMS and RAD tools out there?
I'm looking for free options.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
I guess it would be great if Pgsql had a way to find a database
definition via a system stored procedure like other database platforms
have.
There are two ways I've found so far:
SELECT
attname as name, typname as type, atttypmod - 4 as size,
relhaspkey as is_primary_key, *
FROM
pg_class
One other option, which I had forgotten for a long time, was:
\d object name
...which can describe many things, although this doesn't give you the
CREATE syntax like a pg_dump can do. Please also note that a pg_dump
can dump output to the screen if you don't specify a file, so if
you're only