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

Re: Two novice questions

From: "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov>
To: stafford(at)marine(dot)rutgers(dot)edu
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Two novice questions
Date: 2008-07-14 15:46:05
Message-ID: 264855a00807140846o1e2ba3f7v2f5f4b59fc5850ac@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Mon, Jul 14, 2008 at 11:08 AM, Wm.A.Stafford
<stafford(at)marine(dot)rutgers(dot)edu> wrote:
> 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.

The quoting is used to specify a literal name.  In particular, if you
specify something like:

Name varchar(32)

Without the quotes, this will be case-folded to all lower-case name.
If you use the quotes, the name will not be case-folded.  As a general
RULE, if you use quotes anywhere, you should use them everywhere.  Do
not mix-and-match or you will likely get into trouble.

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

I don't think so.  You will probably want to look at using the psql
executable for mass- or automatic-processing of scripts.

Sean

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2008-07-14 15:55:23
Subject: Re: Two novice questions
Previous:From: Wm.A.StaffordDate: 2008-07-14 15:08:13
Subject: Two novice questions

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