| 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: | Whole Thread | Raw Message | 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 |