| From: | "Anthony E (dot) Greene" <agreene(at)pobox(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Two novice questions |
| Date: | 2001-01-15 21:03:38 |
| Message-ID: | 20010115160338.K645@cp5340 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Sun, 14 Jan 2001 03:40:56 Jonathan Chum wrote:
>I have two problems. One, I would like to know how to remove a database. It
Use "destroydb databasename" at a shell command line.
>My second question is that I have created a table with a column, FID.
>However, when I SELECT FID FROM table, it will result:
Column names should always be lowercase or quoted:
SELECT "FID" FROM forum; (if the column name is "FID" -- unlikely)
or
SELECT fid FROM forum; (if the column name is "fid")
Tony
--
Anthony E. Greene <agreene(at)pobox(dot)com> <http://www.pobox.com/~agreene/>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 239D
Chat: AOL/Yahoo: TonyG05 ICQ: 91183266
Linux. The choice of a GNU Generation. <http://www.linux.org/>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anthony E . Greene | 2001-01-15 21:13:22 | Re: Re: Postgres access using PHP |
| Previous Message | mat | 2001-01-15 19:58:23 | problem with pg_dump |