Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Novice > Two novice ques...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 6 Topic 3172 of 3255
Post > Topic >>

Two novice questions

by stafford@[EMAIL PROTECTED] ("Wm.A.Stafford") Jul 14, 2008 at 11:08 AM

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

-- 
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
 




 6 Posts in Topic:
Two novice questions
stafford@[EMAIL PROTECTED  2008-07-14 11:08:13 
Re: Two novice questions
sdavis2@[EMAIL PROTECTED]  2008-07-14 11:46:05 
Re: Two novice questions
tgl@[EMAIL PROTECTED] (T  2008-07-14 11:55:23 
libpq question
George.Wright@[EMAIL PROT  2008-07-22 15:00:32 
Re: libpq question
George.Wright@[EMAIL PROT  2008-07-24 07:51:13 
Re: Two novice questions
pgsql@[EMAIL PROTECTED]   2008-07-15 01:34:30 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Oct 11 6:00:43 CDT 2008.