Re: Connecting PHP-based Application to Postgres-9.0.3

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