> Let me be a little for specific. I am trying to make a php/pg/apache app
> that when run checks for its database and if not found creates it. To do
> this I first connect to pg first under template1 and check for my
> database in pg_database. If found I close and connect to that database.
> If not found I create it while connected to template1 and then close and
> connect under my database. Here is the code. Maybe I need to post this
> to the php site. But when I look at using a database I need to connect
> to it with a user and dbname. I have been using template1 successfully
> except any new databases after the first one inherit the tables from the
> 1st database and I though the way to get around this was to use
> template0? Am I out in left field about all this?
Your code creates the tables in template1, not in the new database. That's
your problem. You need to fix it so that you pg_connect to the newly
BTW, the approach you're taking is vey insecure and I hope you're not using it
on a public site anywhere.
Aglio Database Solutions
In response to
- template0 at 2004-02-05 23:32:59 from Marcel Wolf
pgsql-novice by date
|Next:||From: Josh Berkus||Date: 2004-02-06 00:31:56|
|Subject: Re: Where do I start?|
|Previous:||From: kynn||Date: 2004-02-06 00:25:17|
|Subject: Where do I start?|