    ALTER TABLE table1 ALTER COLUMN column1 TYPE text;

What is the function to get the current UTC time. I have tried with System.getCurrentTime but i get the current date and time of the device.

Thanks

Android get Current UTC time

I am running a C# application, and during run-time I get the following error:

&gt; The CLR has been unable to transition from COM context 0x20e480 to COM context 0x20e5f0 for 60 seconds. The thread that owns the destination context/apartment is most likely either doing a non pumping wait or processing a very long running operation without pumping Windows messages. This situation generally has a negative performance impact and may even lead to the application becoming non responsive or memory usage accumulating continually over time. To avoid this problem, all single threaded apartment (STA) threads should use pumping wait primitives (such as CoWaitForMultipleHandles) and routinely pump messages during long running operations.

Can anyone please help me out with the problem here?

Thanks a lot.

ContextSwitchDeadlock Was Detected error in C#

I screwed up and created a column as a varchar(255) where that is no longer sufficient. I&#39;ve read that varchar has no performance benefits over text on Postgres, and so would like to convert the varchar to a text column in a safe way that preserves the data.

What&#39;s the best way for me to do this?

Postgres: Convert varchar to text

<p>I screwed up and created a column as a varchar(255) where that is no longer sufficient. I've read that varchar has no performance benefits over text on Postgres, and so would like to convert the varchar to a text column in a safe way that preserves the data.</p>
<p>What's the best way for me to do this?</p>


I regularly need to delete all the data from my PostgreSQL database before a rebuild. How would I do this directly in SQL?

At the moment I&#39;ve managed to come up with a SQL statement that returns all the commands I need to execute: 

    SELECT &#39;TRUNCATE TABLE &#39; ||  tablename || &#39;;&#39; FROM pg_tables WHERE tableowner=&#39;MYUSER&#39;;

But I can&#39;t see a way to execute them programmatically once I have them.

Truncating all tables in a Postgres database

I&#39;m looking for a way to get all rows as `INSERT` statements from one specific table within a database using `pg_dump` in PostgreSQL.

E.g., I have table A and all rows in table A I need as `INSERT` statements, it should also dump those statements to a file.

Is this possible? 

Using pg_dump to only get insert statements from one table within database

I have a Postgre database that has say 10 columns. The fifth column is called `column5`. There are 100 rows in the database and possible values of `column5` are `c5value1, c5value2, c5value3...c5value29, c5value30`. I would like to print out a table that shows how many times each value occurs. 

So the table would look like this:

    Value(of column5)          number of occurrences of the value
         c5value1                              1
         c5value2                              5
         c5value3                              3
         c5value4                              9
         c5value5                              1
         c5value6                              1
            .                                  .
            .                                  .
            .                                  .

What is the command that does that?


How to count number of occurrences for all different values in database column?

I need to set schema path in Postgres so that I don&#39;t every time specify schema dot table e.g. `schema2.table`. 
Set schema path:

    SET SCHEMA PATH a,b,c

only seems to work for one query session on mac, after I close query window the path variable sets itself back to default. 

How can I make it permanent?

Permanently Set Postgresql Schema Path

Where can I find a detailed manual about PostgreSQL naming conventions? (table names vs. camel case, sequences, primary keys, constraints, indexes, etc...)


PostgreSQL naming conventions

I am currently playing around with CSS3 and trying to achieve a text effect like this (the black blurry inner shadow):

![][1]

But I cannot find a way to create text shadows *inside* the text. I wonder whether it is still possible because the box-shadow element is able to render shadow inside like this:

    box-shadow: inset 0px -5px 10px 0px rgba(0, 0, 0, 0.5);

Any ideas?


  [1]: https://i.stack.imgur.com/rw4vf.jpg

Inner text shadow with CSS

I would like to have a text input field containing the &quot;$&quot; sign in the very beginning, and no matter what editing occurs to the field, for the sign to be persistent.

I would be good if only numbers were accepted for input, but that&#39;s just a fancy addition.


HTML text input field with currency symbol

I am trying to add text on an image using the `&lt;canvas&gt;` element. First the image is drawn and on the image the text is drawn. So far so good.

But where I am facing a problem is that if the text is too long, it gets cut off in the start and end by the canvas. I don&#39;t plan to resize the canvas, but I was wondering how to wrap the long text into multiple lines so that all of it gets displayed. Can anyone point me at the right direction?

Text wrap in a &lt;canvas&gt; element

How do I set the color of the text of a label?

    myLabel.setText(&quot;Text Color: Red&quot;);
    myLabel.???

Can I have two seperate colors in one label?

For example here:

The `&quot;Text Color:&quot;` to be black and the `&quot;Red&quot;` to be red.



How do I set the colour of a label (coloured text) in Java?

Is there a method which returns the width ( in pixels ) of a text to be drawn on an Android canvas using the drawText() method according to the Paint used to draw it?

Measuring text width to be drawn on Canvas ( Android )

Why do we always need to specify `VARCHAR(length)` instead of just `VARCHAR`? It is dynamic anyway.

UPD: I&#39;m puzzled specifically by the fact that it is mandatory (e.g. in MySQL).

Why does VARCHAR need length specification?

What&#39;s the difference between the `text` data type and the `character varying` (`varchar`) data types?

According to [the documentation][1]

&gt; If character varying is used without length specifier, the type accepts strings of any size. The latter is a PostgreSQL extension.

and

&gt; In addition, PostgreSQL provides the text type, which stores strings of any length. Although the type text is not in the SQL standard, several other SQL database management systems have it as well.

So what&#39;s the difference?

  [1]: http://www.postgresql.org/docs/8.0/interactive/datatype-character.html

Difference between text and varchar (character varying)

Suppose that I have a SQL table that has a varchar[1000] field called &quot;Remarks&quot;.

I would like to craft a single SQL statement, which when executed, will return 1000, or whatever the size of the varchar field might be changed to in the future.

Something like `SELECT size(Remarks) FROM mytable`.

How do I do this?


How to get the size of a varchar[n] field in one SQL statement?

I&#39;m trying to populate a SQL table with a list of words. The table itself it pretty simple:


    CREATE TABLE WORDS(
      ID BIGINT AUTO_INCREMENT, 
      WORD VARCHAR(128) NOT NULL UNIQUE, 
      PRIMARY KEY(ID)
    );

The problem I&#39;m running into is this: when I do the following inserts back to back

    INSERT INTO WORDS(WORD) VALUES(&#39;Seth&#39;);
    INSERT INTO WORDS(WORD) VALUES(&#39;seth&#39;);

The second insert fails with a constraint violation (&quot;Duplicate entry &#39;seth&#39; for key &#39;WORD&#39;&quot;).

How can I get the `UNIQUE` constraint on `WORD` to be case sensitive?

SQL unique varchar case sensitivity question

If I have a VARCHAR of 200 characters and that I put a string of 100 characters, will it use 200 bytes or it will just use the actual size of the string?

Content Type	Original Author	Original Content on Stackoverflow
Question	William Jones	View Question on Stackoverflow
Solution 1 - Postgresql	rfusca	View Answer on Stackoverflow

Postgres: Convert varchar to text

Postgresql Problem Overview

Postgresql Solutions

Solution 1 - Postgresql

ContextSwitchDeadlock Was Detected error in C#

Android get Current UTC time

Attributions