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(at)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