How to autocapitalize the first character in an input field inside an AngularJS form element?

I saw the jQuery solution already, but believe this has to be done differently in AngularJS by using a directive.
 

How to autocapitalize the first character in an input field in AngularJS?

Here is an exercise from Introductory Statistics with R:

With the rmr data set, plot metabolic rate versus body weight. Fit a linear regression model to the relation. According to the fitted model, what is the predicted metabolic rate for a body weight of 70 kg? Give a 95% confidence interval for the slope of the line.

rmr data set is in the &#39;ISwR&#39; package. It looks like this:

    &gt; rmr
       body.weight metabolic.rate
    1         49.9           1079
    2         50.8           1146
    3         51.8           1115
    4         52.6           1161
    5         57.6           1325
    6         61.4           1351
    7         62.3           1402
    8         64.9           1365
    9         43.1            870
    10        48.1           1372
    11        52.2           1132
    12        53.5           1172
    13        55.0           1034
    14        55.0           1155
    15        56.0           1392
    16        57.8           1090
    17        59.0            982
    18        59.0           1178
    19        59.2           1342
    20        59.5           1027
    21        60.0           1316
    22        62.1           1574
    23        64.9           1526
    24        66.0           1268
    25        66.4           1205
    26        72.8           1382
    27        74.8           1273
    28        77.1           1439
    29        82.0           1536
    30        82.0           1151
    31        83.4           1248
    32        86.2           1466
    33        88.6           1323
    34        89.3           1300
    35        91.6           1519
    36        99.8           1639
    37       103.0           1382
    38       104.5           1414
    39       107.7           1473
    40       110.2           2074
    41       122.0           1777
    42       123.1           1640
    43       125.2           1630
    44       143.3           1708

I know how to calculate the predicted y at a given x but how can I calculate the confidence interval for the slope?

How to calculate the 95% confidence interval for the slope in a linear regression model in R

Why psql can&#39;t find relation name for existing table?

I&#39;m a postgres novice. 

I installed the postgres.app for mac. I was playing around with the psql commands and I accidentally dropped the postgres database. I don&#39;t know what was in it. 

I&#39;m currently working on a tutorial: http://www.rosslaird.com/blog/building-a-project-with-mezzanine/

And I&#39;m stuck at `sudo -u postgres psql postgres`

ERROR MESSAGE: `psql: FATAL:  role &quot;postgres&quot; does not exist`

$ which psql 
     
    /Applications/Postgres.app/Contents/MacOS/bin/psql


This is what prints out of `psql -l`

	                                List of databases
	    Name    |   Owner    | Encoding | Collate | Ctype |     Access privileges     
	------------+------------+----------+---------+-------+---------------------------
	 user       | user       | UTF8     | en_US   | en_US | 
	 template0  | user       | UTF8     | en_US   | en_US | =c/user                  +
	            |            |          |         |       | user      =CTc/user      
	 template1  | user       | UTF8     | en_US   | en_US | =c/user                  +
	            |            |          |         |       | user      =CTc/user      
	(3 rows)



So what are the steps I should take? Delete an everything related to psql and reinstall everything?

Thanks for the help guys!

psql: FATAL: role &quot;postgres&quot; does not exist

postgreSQL: how to duplicate a row

I tried to run simple SQL command:

    select * from site_adzone;

and I got this error

&gt; ERROR:  permission denied for relation site_adzone

What could be the problem here?

I tried also to do select for other tables and got same issue. I also tried to do this:

    GRANT ALL PRIVILEGES ON DATABASE jerry to tom;

but I got this response from console

&gt; WARNING:  no privileges were granted for &quot;jerry&quot;

Does anyone have any idea what can be wrong?

Permission denied for relation

I have seen `::` in variety of places involving postgres code I have seen on the net. For example:

    SELECT &#39;{apple,cherry apple, avocado}&#39;::text[];

It seems to be some sort of cast. What exactly is `::` in postgres and when should it be used?

I tried a bit of googling and searched the Postgres docs for `::` but got no good results.  
I tried following searches in Google: 

 - postgres double colon 
 - postgres :: 
 - :: 

I tried the following searches in the postgres docs search button 

 - double colon 
 - double colon cast 
 - :: 
 
This was almost embarrassing to ask on SO, but I figured Google will hopefully see this answer for other people in the future.

What does :: do in PostgreSQL?

When I do a `\dt` in psql I only get a listing of tables in the current schema (`public` by default).

How can I get a list of all tables in all schemas or a particular schema?

List tables in a PostgreSQL schema

I want to change schema name of table `Employees` in Database. In the current table `Employees` database schema name is `dbo` I want to change it to `exe`. How can I do it ? 

Example:

FROM 

    dbo.Employees

TO

    exe.Employees


I tried with this query:

    ALTER SCHEMA exe TRANSFER dbo.Employees

But this gives me an error:

&gt; Cannot alter the schema &#39;exe&#39;, because it does not exist or you do not
&gt; have permission.

What did I miss? 

Change Schema Name Of Table In SQL

I managed to change my project name, but how do I change the name displayed  directly to the left of &quot;iOS Simulator&quot;?


How to change the name of the active scheme in Xcode?

I&#39;m trying to create a Postgres database for the first time.

I assigned basic read-only permissions to the DB role that must access the database from my PHP scripts, and I have a curiosity: If I execute

    GRANT some_or_all_privileges ON ALL TABLES IN SCHEMA schema TO role;

is there any need to also execute this?

    GRANT USAGE ON SCHEMA schema TO role;

From the [documentation][1]:

&gt; USAGE: For schemas, allows access to objects contained in the
&gt; specified schema (assuming that the objects&#39; own privilege
&gt; requirements are also met). Essentially this allows the grantee to
&gt; &quot;look up&quot; objects within the schema.

I think that if I can select or manipulate any data contained in the schema, I can access to any objects of the schema itself. Am I wrong? If not, what is `GRANT USAGE ON SCHEMA` used for? And what does the documentation mean exactly with &quot;assuming that the objects&#39; own privilege requirements are also met&quot;?

  [1]: http://www.postgresql.org/docs/9.1/static/sql-grant.html

What does GRANT USAGE ON SCHEMA do exactly?

I have applied for an internship in a company and as a question they have asked me to create a schema for their company with certain requirements and mail them the *DDL* file. I have installed Oracle database 11g Express edition, but how do I create a new schema in Oracle database 11g? I have searched in the net for a solution but I could not understand what to do. And after creating a schema, which file should I mail them?

How to create a new schema/new user in Oracle Database 11g?

I&#39;m currently having problems in creating a schema for the document below. The response from the server always returns the &quot;trk&quot; field values as [Object]. Somehow I have no idea how this should work, as I tried at least all approaches which made sense to me ;-)

If this helps, my Mongoose version is 3.6.20 and MongoDB 2.4.7
And before I forget, it would be nice to also set it as Index (2d)

Original data:

    {
        &quot;_id&quot;: ObjectId(&quot;51ec4ac3eb7f7c701b000000&quot;),
        &quot;gpx&quot;: {
            &quot;metadata&quot;: {
                &quot;desc&quot;: &quot;N&#252;rburgring VLN-Variante&quot;,
                &quot;country&quot;: &quot;de&quot;,
                &quot;isActive&quot;: true
            },
        &quot;trk&quot;: [
        {
            &quot;lat&quot;: 50.3299594,
            &quot;lng&quot;: 6.9393006
        },
        {
            &quot;lat&quot;: 50.3295046,
            &quot;lng&quot;: 6.9390688
        },
        {
            &quot;lat&quot;: 50.3293714,
            &quot;lng&quot;: 6.9389939
        },
        {
            &quot;lat&quot;: 50.3293284,
            &quot;lng&quot;: 6.9389634
        }]
        }
    }

Mongoose Schema:

    var TrackSchema = Schema({
                _id: Schema.ObjectId,
                gpx: {
                    metadata: {
                        desc: String,
                        country: String,
                        isActive: Boolean
                    },
                    trk: [{lat:Number, lng:Number}]
                }
            }, { collection: &quot;tracks&quot; });

The response from the Network tab in Chrome always looks like this (that&#39;s only the trk-part which is wrong) : 

    { trk: 
          [ [Object],
            [Object],
            [Object],
            [Object],
            [Object],
            [Object],

I already tried different Schema definitions for &quot;trk&quot;:

 1. trk: Schema.Types.Mixed 
 2. trk: [Schema.Types.Mixed] 
 3. trk:[ { type:[Number], index: &quot;2d&quot; }]

Hope you can help me ;-)

How to define object in array in Mongoose schema correctly with 2d geo index

Here is my simple anonymous code block:

    do $$
      declare foo varchar(50) := &#39;&#39;;
      begin
        for a in
          select a from (values(&#39;foo&#39;), (&#39;bar&#39;), (&#39;fooBar&#39;)) s(a)
        loop
          foo := a;
          print foo;
        end loop;
      end;
    $$;

When I run it:

    psql -f test.sql

I get this error:

    psql:test.sql:11: ERROR:  loop variable of loop over rows must be a record or row variable or list of scalar variables
    LINE 4:     for a in
                ^

psql - loop variable of loop over rows must be a record or row variable or list of scalar variables

I have a database that was exported with pg_dump, but now when I&#39;m trying to import it again with:

    psql -d databasename &lt; mydump.sql

It fails trying to grant roles to people that don&#39;t exist. (error says &#39;Role &quot;xxx&quot; does not exist&#39;) 

Is there a way to import and set all the roles automatically to my user?

Import postgres database without roles

I&#39;m using the PostgreSql app for mac (http://postgresapp.com/). I&#39;ve used it in the past on other machines but it&#39;s giving me some trouble when installing on my macbook. I&#39;ve installed the application and I ran:

    psql -h localhost

It returns:
    
    psql: FATAL:  database &quot;&lt;user&gt;&quot; does not exist

It seems I can&#39;t even run the console to create the database that it&#39;s attempting to find. The same thing happens when I just run:

    psql 

or if I launch psql from the application drop down menu:

Machine stats:

- OSX 10.8.4

- psql (PostgreSQL) 9.2.4

Any help is appreciated. 


I&#39;ve also attempted to install PostgreSql via homebrew and I&#39;m getting the same issue. I&#39;ve also read the applications documentation page that states: 

&gt; When Postgres.app first starts up, it creates the $USER database,
&gt; which is the default database for psql when none is specified. The
&gt; default user is $USER, with no password.

So it would seem the application is not creating $USER however I&#39;ve installed-&gt;uninstalled-reinstalled several times now so it must be something with my machine.

I found the answer but I&#39;m not sure exactly how it works as the user who answered on this thread -&gt; https://stackoverflow.com/questions/13515834/getting-postgresql-running-in-mac-database-postgres-does-not-exist didn&#39;t follow up. I used the following command to get psql to open: 

    psql -d template1

*I&#39;ll leave this one unanswered until someone can provide an explanation for why this works.*

psql: FATAL: database &quot;&lt;user&gt;&quot; does not exist

A password is visible in my psql prompt (by pushing up arrow to view previous inputted commands). So I would like to delete that entry from the psql client. 

Other resources([1], [2]) claim that psql client history is kept in is a `~/.psql_history` file, however this file is simply not there. (it&#39;s not in `.bash_history` either)

So **there must be another file where the history of psql prompt is kept, any ideas where?**

I log in to my prompt like this 
`sudo -u postgres psql my_db`

Note: I am working on `Ubuntu 12.04`


  [1]: http://www.thegeekstuff.com/2009/04/15-practical-postgresql-database-adminstration-commands/
  [2]: https://stackoverflow.com/questions/6654121/postgresql-psql-history-to-dev-null

Content Type	Original Author	Original Content on Stackoverflow
Question	eonil	View Question on Stackoverflow
Solution 1 - Postgresql	eonil	View Answer on Stackoverflow

Why psql can't find relation name for existing table?

Postgresql Problem Overview

Postgresql Solutions

Solution 1 - Postgresql

How to calculate the 95% confidence interval for the slope in a linear regression model in R

How to autocapitalize the first character in an input field in AngularJS?

Attributions