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 |