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
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 |