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
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 loc
Randal L. Schwartz wrote:
> >>>>> "Google" == Google Mike <[EMAIL PROTECTED]> writes:
>
> Google> As a PostgreSQL admin or developer, you may be asked to deploy a Linux
> Google> Apache PHP PostgreSQL application.
>
> Not me. I'll be
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
p
One other option, which I had forgotten for a long time, was:
\d
...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 outputting the
