Two novice questions

From: "Wm(dot)A(dot)Stafford" <stafford(at)marine(dot)rutgers(dot)edu>
To: pgsql-novice(at)postgresql(dot)org
Subject: Two novice questions
Date: 2008-07-14 15:08:13
Message-ID: 487B6BDD.1060104@marine.rutgers.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have received a collection of scripts to be used to build a PostgreSQL
db and I can't figure out the following.

1. Usage of quotes in the scripts.
The following comes from a script to build and populate a table:
gid serial PRIMARY KEY,
"fid_" int4,
Why is the second column name in quotes, i.e. what is the difference
between fid_ int4 and "fid_" int 4.

In a similar vein, this comes from a script that creates a couple of
tables:
create table schema1."cache" ( ...
create table schema1.cache2 ( ...
Here one schema name is quoted and the other is not.

2. How does one run a script from PGAdmin? I have been 'opening' the
script file then hitting the run button. Is there a way to just specify
the path to the script?

Thanks for any help or pointers,
-=beeky

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2008-07-14 15:46:05 Re: Two novice questions
Previous Message Leví Teodoro da Silva 2008-07-14 14:29:48 [PostgreSQL with OpenSolaris]Configuration