The [COPY command][1] should do that all by itself if your table uses a `serial` column for the `id`:

&gt; If there are any columns in the table that are not in the column list, COPY FROM will insert the default values for those columns.

So you should be able to say:

    copy table_name(city, zipcode) from ...

and the `id` will be generated as usual. If you don&#39;t have a `serial` column for `id` (or a manually attached sequence), then you could hook up a sequence by hand, do your COPY, and then detach the sequence.

  [1]: http://www.postgresql.org/docs/current/static/sql-copy.html

I am drawing a bar chart using `highchart.js`

**I do not want to show the x - axis data values.**

Can any one tell me which option does it?
&lt;br /&gt;
full config:

    var chart = new Highcharts.Chart({
                    chart: {
                        renderTo: container,
                        defaultSeriesType: &#39;bar&#39;
                    },
                    title: {
                        text: null
                    },
                    subtitle: {
                        text: null
                    },
                    xAxis: {
                        categories: [&#39;&#39;],
                        title: {
                            text: null
                        },
                        labels: {enabled:true,y : 20, rotation: -45, align: &#39;right&#39; }
    
                    },
                    yAxis: {
                        min: 0,
                        gridLineWidth: 0,
                        title: {
                            text: &#39;&#39;,
                            align: &#39;high&#39;
                        }
                    },
                    tooltip: {
                        formatter: function () {
                            return &#39;&#39;;
                        }
                    },
                    plotOptions: {
                        bar: {
                            dataLabels: {
                                enabled: true
                            },
                            pointWidth: 35,
                            color: &#39;#D9CDC1&#39;
                        }
                    },
                    legend: {
                        enabled: false
                    },
                    credits: {
                        enabled: false
                    },
                    series: [{
                        name: &#39;Year 1800&#39;,
                        data: [107]
                    }]
                });

how to hide highchart x - axis data values

&gt; **Possible Duplicate:**  
&gt; [Need to split arrays to sub arrays of specified size in Ruby](https://stackoverflow.com/questions/3864139/need-to-split-arrays-to-sub-arrays-of-specified-size-in-ruby)  

&lt;!-- End of automatically inserted text --&gt;

I&#39;m looking to take an array---say [0,5,3,8,21,7,2] for example---and produce an array of arrays, split every so many places.  If the above array were set to a, then

    a.split_every(3)

would return [[0,5,3],[8,21,7][2]]

Does this exist, or do I have to implement it myself?

Split array up into n-groups of m size?

I have a CSV file with two columns: city and zipcode. I want to be able to copy this file into a PostgreSQL table using the `copy` command and at the same time auto generate the `id` value. 

The table has the following columns: `id`, `city`, and `zipcode`.

My CSV file has only: `city` and `zipcode`.


PostgreSQL copy command generate primary key id

I have a CSV file with two columns: city and zipcode. I want to be able to copy this file into a PostgreSQL table using the <code>copy</code> command and at the same time auto generate the <code>id</code> value.
The table has the following columns: <code>id</code>, <code>city</code>, and <code>zipcode</code>.
My CSV file has only: <code>city</code> and <code>zipcode</code>.

[I posted a related question](https://stackoverflow.com/q/7922211/902825), but this is another part of my puzzle.

I would like to get the OLD value of a column from a row that was UPDATEd - WITHOUT using triggers (nor stored procedures, nor any other extra, non -SQL/-query entities).

I have a query like this:

       UPDATE my_table
          SET processing_by = our_id_info  -- unique to this worker
        WHERE trans_nbr IN (
                            SELECT trans_nbr
                              FROM my_table
                             GROUP BY trans_nbr
                            HAVING COUNT(trans_nbr) &gt; 1
                             LIMIT our_limit_to_have_single_process_grab
                           )
    RETURNING row_id;

If I could do `FOR UPDATE ON my_table` at the end of the subquery, that&#39;d be divine (and fix my other question/problem). But that won&#39;t work: can&#39;t combine this with `GROUP BY` (which is necessary for figuring out the count). Then I could just take those trans_nbr&#39;s and do a query first to get the (soon-to-be-) former `processing_by` values.

I&#39;ve tried doing like:

       UPDATE my_table
          SET processing_by = our_id_info -- unique to this worker
         FROM my_table old_my_table
         JOIN (
                 SELECT trans_nbr
                   FROM my_table
               GROUP BY trans_nbr
                 HAVING COUNT(trans_nbr) &gt; 1
                  LIMIT our_limit_to_have_single_process_grab
              ) sub_my_table
           ON old_my_table.trans_nbr = sub_my_table.trans_nbr
        WHERE     my_table.trans_nbr = sub_my_table.trans_nbr
          AND my_table.processing_by = old_my_table.processing_by
    RETURNING my_table.row_id, my_table.processing_by, old_my_table.processing_by

But that can&#39;t work; `old_my_table` is not visible outside the join; the `RETURNING` clause is blind to it.

I&#39;ve long since lost count of all the attempts I&#39;ve made; I have been researching this for literally hours.

If I could just find a bullet-proof way to lock the rows in my subquery - and ONLY those rows, and WHEN the subquery happens - all the concurrency issues I&#39;m trying to avoid would disappear ...

---

**UPDATE:** I had a typo in the non-generic code of the above. I retried after Erwin Brandstetter suggested it should work. Since it took me so long to find this sort of solution, perhaps my embarrassment is worth it? At least this is on SO for posterity now...  :&gt;

What I now have (that works) is like this:

       UPDATE my_table
          SET processing_by = our_id_info -- unique to this worker
         FROM my_table AS old_my_table
        WHERE trans_nbr IN (
                              SELECT trans_nbr
                                FROM my_table
                            GROUP BY trans_nbr
                              HAVING COUNT(*) &gt; 1
                               LIMIT our_limit_to_have_single_process_grab
                           )
          AND my_table.row_id = old_my_table.row_id
    RETURNING my_table.row_id, my_table.processing_by, old_my_table.processing_by AS old_processing_by

The `COUNT(*)` is per a suggestion from **Flimzy** in a comment on my other (linked above) question.

[Please see my other question](https://stackoverflow.com/q/7922211/902825) for correctly implementing concurrency and even a non-blocking version; THIS query merely shows how to get the old and new values from an update, ignore the bad/wrong concurrency bits.

Return pre-UPDATE column values using SQL only

To compare databases of different vendors (Oracle, SQL Server, DB2, MySQL, and PostgreSQL) how can I identify any object uniquely and do I need a catalog? For instance, In Java&#39;s DatabaseMetadata I should specify catalog and schema fooPattern at least. 

Is it true that catalog is just an abstraction of data storage?

Relationship between catalog, schema, user, and database instance

I need to know the number of rows in a table to calculate a percentage. If the total count is greater than some predefined constant, I will use the constant value. Otherwise, I will use the actual number of rows.

I can use `SELECT count(*) FROM table`. But if my constant value is *500,000* and I have *5,000,000,000* rows in my table, counting all rows will waste a lot of time.

Is it possible to stop counting as soon as my constant value is surpassed?

I need the exact number of rows only as long as it&#39;s below the given limit. Otherwise, if the count is above the limit, I use the limit value instead and want the answer as fast as possible.

Something like this:

    SELECT text,count(*), percentual_calculus()  
    FROM token  
    GROUP BY text  
    ORDER BY count DESC;

Fast way to discover the row count of a table in PostgreSQL

I have this function in PostgreSQL, but I don&#39;t know how to return the result of the query:

    CREATE OR REPLACE FUNCTION wordFrequency(maxTokens INTEGER)
      RETURNS SETOF RECORD AS
    $$
    BEGIN
        SELECT text, count(*), 100 / maxTokens * count(*)
        FROM (
            SELECT text
	    FROM token
	    WHERE chartype = &#39;ALPHABETIC&#39;
	    LIMIT maxTokens
        ) as tokens
        GROUP BY text
        ORDER BY count DESC
    END
    $$
    LANGUAGE plpgsql;

But I don&#39;t know how to return the result of the query inside the PostgreSQL function.

I found that the return type should be `SETOF RECORD`, right? But the return command is not right.

What is the right way to do this?

How to return result of a SELECT inside a function in PostgreSQL?

How can I tell if my Postgresql server is running or not?

I&#39;m getting this message:

    [~/dev/working/sw] sudo bundle exec rake db:migrate 
    rake aborted!
    could not connect to server: Connection refused
    	Is the server running on host &quot;localhost&quot; and accepting
    	TCP/IP connections on port 5432?


Update:

    &gt; which postgres
    /usr/local/bin/postgres
    &gt; pg_ctl -D /usr/local/bin/postgres -l /usr/local/bin/postgres/server.log start
    pg_ctl: could not open PID file &quot;/usr/local/bin/postgres/postmaster.pid&quot;: Not a directory

Update 2:

    &gt;pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
    server starting
    sh: /usr/local/var/postgres/server.log: No such file or directory

Content Type	Original Author	Original Content on Stackoverflow
Question	user373201	View Question on Stackoverflow
Solution 1 - Postgresql	mu is too short	View Answer on Stackoverflow

PostgreSQL copy command generate primary key id

Postgresql Problem Overview

Postgresql Solutions

Solution 1 - Postgresql

Split array up into n-groups of m size?

how to hide highchart x - axis data values

Attributions