blog.rhodiumtoad.org.uk

The Rhodium Toad | an experimental blog

Loading data from JSON files. Another quick one from the IRC channel. The problem: to import a json data file (array of objects) on the client system into PostgreSQL without needing to mess with external scripting for the job (and without relying on Unix tools). This approach works for files under 1GB only, of course. Put the above in a file, e.g. Psql -v filename="myfile.json" -d mydb -f import.sql. Perfect hash function for weekday names. Call (it makes use of the fact that. Continue reading →. I’...

http://blog.rhodiumtoad.org.uk/

OVERVIEW OF blog.rhodiumtoad.org.uk

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

18

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR BLOG.RHODIUMTOAD.ORG.UK

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

July

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Saturday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.4 out of 5 with 10 reviews

5 star

1

4 star

6

3 star

1

2 star

0

1 star

2

Hey there! Start your review of blog.rhodiumtoad.org.uk

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

1.8 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT BLOG.RHODIUMTOAD.ORG.UK

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

18

SSL

EXTERNAL LINKS

3

SITE IP

217.160.0.201

LOAD TIME

1.798 sec

SCORE

6.2

PAGE TITLE

The Rhodium Toad | an experimental blog | blog.rhodiumtoad.org.uk Reviews

<META> DESCRIPTION

Loading data from JSON files. Another quick one from the IRC channel. The problem: to import a json data file (array of objects) on the client system into PostgreSQL without needing to mess with external scripting for the job (and without relying on Unix tools). This approach works for files under 1GB only, of course. Put the above in a file, e.g. Psql -v filename=myfile.json -d mydb -f import.sql. Perfect hash function for weekday names. Call (it makes use of the fact that. Continue reading →. I&#8217...

<META> KEYWORDS

1 the rhodium toad

2 an experimental blog

3 skip to content

4 posted on

5 andrew

6 import sql

7 and run as

8 posted in

9 planetpg

10 postgres

CONTENT

Page content here

KEYWORDS ON PAGE

the rhodium toad,an experimental blog,skip to content,posted on,andrew,import sql,and run as,posted in,planetpg,postgres,1 comment,postgresql,substring,ascii,leave a comment,2 comments,the rule challenge,peeves,5 comments,max lag e,max new start,bcnf,meta

SERVER

Apache

POWERED BY

PHP/5.6.34

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

The Rhodium Toad | an experimental blog | blog.rhodiumtoad.org.uk Reviews

https://blog.rhodiumtoad.org.uk

Loading data from JSON files. Another quick one from the IRC channel. The problem: to import a json data file (array of objects) on the client system into PostgreSQL without needing to mess with external scripting for the job (and without relying on Unix tools). This approach works for files under 1GB only, of course. Put the above in a file, e.g. Psql -v filename="myfile.json" -d mydb -f import.sql. Perfect hash function for weekday names. Call (it makes use of the fact that. Continue reading →. I&#8217...

INTERNAL PAGES

blog.rhodiumtoad.org.uk

1

Andrew | The Rhodium Toad

http://blog.rhodiumtoad.org.uk/author/andrew

I’ve made this challenge on IRC several times, and I think on the mailing lists too, but I’m putting it up here for reference. I’m not a fan of rules. I’ve used them in production code in the past, though … Continue reading →. Range aggregation with window functions. Comments Off on Range aggregation with window functions. Selecting random rows from a table. Reading XML files into the database. This came up as a question on IRC: how to read an XML file on the server into a table column? People have funny...

2

Bloggery | The Rhodium Toad

http://blog.rhodiumtoad.org.uk/category/bloggery

I have no idea if I want to keep a blog. So let’s see what happens, if anything. Proudly powered by WordPress.

3

March | 2009 | The Rhodium Toad

http://blog.rhodiumtoad.org.uk/2009/03

Monthly Archives: March 2009. Selecting random rows from a table. The question of how to select some random items from a table is one that comes up fairly often in the IRC channel (and as the subject of blog posts, such as this one from depesz). While there is a … Continue reading →. Proudly powered by WordPress.

4

About | The Rhodium Toad

http://blog.rhodiumtoad.org.uk/about

What’s with the silly name? That all came from an incident on Freenode’s #postgresql channel, when some other user had a rather surreal /quit message involving Rhodium (a rare platinum-group metal) and a toad. I used the name as a joke, but decided to stick with it for a while. So who are you then? If you can’t find that out yourself, you don’t need to know. Leave a Reply Cancel reply. You must be logged in. To post a comment. Proudly powered by WordPress.

5

December | 2008 | The Rhodium Toad

http://blog.rhodiumtoad.org.uk/2008/12

Monthly Archives: December 2008. UUID generation for PostgreSQL 8.3 on FreeBSD. A couple of weeks ago I whomped up a quick module in response to someone on IRC who was unable to get contrib/uuid-ossp working on FreeBSD (which turns out to be due to a nasty conflict between misc/ossp-uuid and libc). … Continue reading →. I have no idea if I want to keep a blog. So let’s see what happens, if anything. Proudly powered by WordPress.

UPGRADE TO PREMIUM TO VIEW 13 MORE

TOTAL PAGES IN THIS WEBSITE

18

LINKS TO THIS WEBSITE

tapoueh.org

Expertise PostgreSQL

http://www.tapoueh.org/blog/2015/05/25-JUG-Montpellier

Monday, May 25 2015. All Your Base Conference 2015. PostgreSQL au JUG de Montpellier. J'ai eu le plaisir de présenter PostgreSQL au Java User Group de Montpellier. Le 20 mai dernier dans le cadre d'une soirée PostgreSQL is YeSQL. L'accueil réservé par le. A été parfait et je tiens à les remercier pour une très bonne soirée de partage et d'échanges autour de PostgreSQL. Puis nous avons continué la soirée avec une présentation des Extensions PostgreSQL, dont ce blog regorge d'exemples :. August, 29 2014.

UPGRADE TO PREMIUM TO VIEW 2 MORE

TOTAL LINKS TO THIS WEBSITE

3

OTHER SITES

blog.rhoadssinon.com

Rhoads & Sinon Blog - Employment, Labor, & Health Care Law

Visit Rhoads and Sinon. Department of Labor Issues New Interpretation on Independent Contractors, Says Most Workers are Employees. 1 Work as an Integral Part of the Employer’s Business. 2 Worker’s Managerial Skills Affect Worker’s Opportunity for Profit or Loss. Worker’s Relative Investment Compared to the Employer’s Investment. Work Performed Requires Special Skill and Initiative. 5 Permanent or Indefinite Relationship. Nature and Degree of Employer’s Control. What Should Employers Do Now. For more info...

blog.rhodasol.es

Blog Rhodasol | Mayoristas agencias viajes - Destinos y consejos para agencias de viajes

Esquí y nieve para estudiantes en los Pirineos y Andorra. Diversión para toda la familia en PortAventura World esta Semana Santa. Semana Santa: playa o ciudad para las primeras vacaciones del año. 7 marzo, 2018. Los parques temáticos de Tenerife a un paso del Hard Rock Hotel Tenerife. Además de por su paisaje y clima, Tenerife es, como bien saben desde Rhodasol, conocida también por su Leer más. 5 marzo, 2018. Consigue descuentos y ventajas con la reserva anticipada de tus vacaciones. 21 febrero, 2018.

blog.rhodders.com

Rhodders Rants | NOT Just another WordPress site

NOT Just another WordPress site. March 9, 2011. Originally published in Spark* student newspaper. To fit this article into it’s section It had to be edited, here you see it in its entirety…. I am no fashion expert. Hence I am normally confined to the ranting, shouting opinionated regions known as the comment or debate section. But onesies, come on! If I want to wear a onesie, I will, SO THERE! Do you agree or disagree with me? Either way post a comment below. The point of pointlessness. February 11, 2011.

blog.rhodesian-ridgeback.dk

Blog Photos

blog.rhodesteamtexas.com

Blog - Rhodes Team Texas Blog

941 Keeler Street, Lantana, TX 76226 – Be One of the First Buyers to Learn About This Property! Coming Soon in Lantana, Texas. How Much is Your Castle Hills Home Worth? How Much is Your Coppell Home Worth? How Much is Your Coppell Home Worth? How Much is Your Flower Mound Home Worth? How Much is Your Lantana Home Worth? How Much is Your McKinney Home Worth? How Much is Your Plano Home Worth? How Much is Your Southlake Home Worth? Interested in Buying and/or Selling a Home in North Texas? Hot New Listings...

blog.rhodiumtoad.org.uk

The Rhodium Toad | an experimental blog

Loading data from JSON files. Another quick one from the IRC channel. The problem: to import a json data file (array of objects) on the client system into PostgreSQL without needing to mess with external scripting for the job (and without relying on Unix tools). This approach works for files under 1GB only, of course. Put the above in a file, e.g. Psql -v filename="myfile.json" -d mydb -f import.sql. Perfect hash function for weekday names. Call (it makes use of the fact that. Continue reading →. I&#8217...

blog.rhodrirdavies.com

Rhodri r Davies

Writing, blogging, reporting. August 17, 2014. Letter from Argentina – The Illusionary Poor. Politicians debate the level of poverty while life gets tougher for the urban poor. You could smell the vegetables being stewed from a few blocks away. The aroma pricked the noses of a handful of. The Buenos Aires sun warmed thousands of protesters one Wednesday afternoon in May. Green, blue and white flags and banners of unions and movements for rubbish pickers, factory workers, pensioners, bus drivers fille...

blog.rhoen-adventures.de

Rhön-Adventures | BLOG |

Am Jan 15, 2014 in Allgemein. Neue Schneeschuhe für Rhön Adventures. Die Schneeschuhe lassen sich schnell und einfach auf die passende Schuhgröße (35-46) einstellen und durch einen Ratschengurt gut am. Am Nov 15, 2013 in Allgemein. GPS – Geocaching – Abenteuer. Am Nov 4, 2013 in Allgemein. Mit dem selbstgebautem Kanu “Miako. Die Antwort ist ganz einfach. Es stand die Taufe und Jungfernfahrt von “Miakotah” an. Das ist ein Kanu, dass in langer, fleißiger Arbeit in der Gemeindewerkstatt ...Die Skilifte auf ...

blog.rhoen-park-hotel.de

Home | Rhön Park Hotel

Im Herzen der Rhön. Lassen Sie sich verzaubern von besonderen Geschichten aus dem Biosphärenreservat Rhön. Träumen Sie sich aus dem Alltag und tauchen Sie ein in Ihren nächsten Rhöner Urlaub! Wir zeigen Ihnen, wie unterschiedlich Sie hier Erholung erleben können, welche kulturellen Highlights auf Sie warten und stellen Ihnen Menschen vor, die nicht nur in der Rhön leben, sondern in besonderer Weise zu der Einzigartigkeit der Region beitragen. Geschichten aus der Rhön. Geschichten aus der Rhön. Unser Körp...

blog.rhoennet.net

Rhoennet Blog | Wir Eichenzeller sind schneller

Trailer – Glasfaserprojekt Eichenzell. Vergleich altes Kupfernetz mit neuem Glasfasernetz. Vom Hausanschluss zur FritzBox. Betriebskommission vom 11.08.2015 – Keinen Ausbau im Cluster 5-1 – Keinen Hausanschluss mehr ohne Dienst. August 12, 2015. Nach der gestrigen Betriebskommission des Eigenbetrieb Breitband Eichenzell, gibt es einige Neuigkeiten zum Ausbau des Kernortes. Anbei die offizielle Pressemitteilung. Vielen Dank und noch einen schönen Abend. Neue Firmware für FRITZ! Juli 28, 2015. Juli 22, 2015.

blog.rhohub.com

RhoMobile Blog

Back to RhoMobile.com. RhoMobile Suite 5.2.2 is Available. What is new in this release:. RhoMobile Suite 5.2.2 features a completely redesigned licensing model. From 5.2.2 you no longer purchase licenses to run on a specific device or that are tied to a specific application, instead licenses are purchased on a per-developer basis and integrated with the re-branded Rhomobile.com. Website, the Rho cloud build solution. Full details of the new license model are available from our licensing doc. From 5.0...