Re: Connecting PHP-based Application to Postgres-9.0.3

[Rich Shepard <rshepard@xxxxxxxxxxxxxxx>]

On Thu, 7 Apr 2011, Alan Hodgson wrote:

> Can you connect to the database with psql using the same credentials?  PHP
> will use the same underlying postgresql library to connect.

Alan,

  If you mean can I as a user connect to that same database, the answer is
yes:

[rshepard@salmo ~]$ psql cms
psql (9.0.3)
Type "help" for help.

cms=# \d
                        List of relations
 Schema |               Name                |   Type   |  Owner 
--------+-----------------------------------+----------+----------
 public | cms_additional_htmlblob_users     | table    | rshepard
 public | cms_additional_htmlblob_users_seq | sequence | rshepard
 public | cms_additional_users              | table    | rshepard
 public | cms_additional_users_seq          | sequence | rshepard
 public | cms_admin_bookmarks               | table    | rshepard
 public | cms_admin_bookmarks_seq           | sequence | rshepard
 public | cms_admin_recent_pages            | table    | rshepard
 public | cms_admin_recent_pages_seq        | sequence | rshepard
 public | cms_adminlog                      | table    | rshepard
 public | cms_content                       | table    | rshepard
 public | cms_content_props                 | table    | rshepard
 public | cms_content_props_seq             | sequence | rshepard
 public | cms_content_seq                   | sequence | rshepard
 public | cms_crossref                      | table    | rshepard
 public | cms_css                           | table    | rshepard
 public | cms_css_assoc                     | table    | rshepard
 public | cms_css_seq                       | sequence | rshepard

  etc.

  So, what can I do here?

Rich