Re: How to query information schema from shell script

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Jon Horsman <horshaq(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: How to query information schema from shell script
Date: 2006-10-28 04:09:35
Message-ID: 840218.2181.qm@web31804.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> In my original email i forgot to mentioned i need to know if the
> database exists or not from the shell script. If it doesn't exist i
> would then create it. Currently i was just creating the db everytime
> our db script is run (since it doesn't hurt the db) but this generates
> the 'db already exists' log and I now have the requirement that the
> users not see that log. ie, don't run createdb if it already exists.
>
> In looking through the postgres docs i can see how to check if a table
> exists but not how a db exists.
>
> Again, thanks for the help.

psql -l

Regards,

Richard Broersma Jr.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Broersma Jr 2006-10-28 14:38:59 Re: Case Preservation disregarding case sensitivity?
Previous Message Joe 2006-10-28 02:38:52 Re: Case Preservation disregarding case sensitivity?