Skip site navigation (1) Skip section navigation (2)

Re: Two novice questions

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 (view raw or flat)
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/>

In response to

pgsql-novice by date

Next:From: Anthony E . GreeneDate: 2001-01-15 21:13:22
Subject: Re: Re: Postgres access using PHP
Previous:From: matDate: 2001-01-15 19:58:23
Subject: problem with pg_dump

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group