List of casts in PostgreSQL

09 May 2005   0 comments   Linux

Mind That Age!

This blog post is 12 years old! Most likely, its content is outdated. Especially if it's technical.

Powered by Fusion×

Learned something new today that will come in very handy next time I'm about to pick up a manual or search the PostgreSQL documentation with Google.

In psql if you run \dC you get a list of casts. Here's the header:

                           List of casts
   Source type    |    Target type    |   Function    | Implicit? 
------------------+-------------------+---------------+-------------

This is very handy when you need to know, for example, which cast to use when to cast a value of type date to timestamp without time zone you use timestamp. Most of these are pretty obvious and the PostgreSQL book is never far away on my desk, but the interesting thing is that I came across this function by accident when running psql.

(was this the most boring thing I've written here in a long time?)

Follow @peterbe on Twitter

Comments

Thank you for posting a comment

Your email will never ever be published


Related posts

Previous:
Kingdom of Crap 07 May 2005
Next:
Susan Senator's book 11 May 2005
Related by Keyword:
How do log ALL PostgreSQL SQL happening 20 July 2015
Fastest database for Tornado 09 October 2013
Postgres collation errors on CITEXT fields when upgrading to 9.1 21 May 2012
Connecting with psycopg2 without a username and password 24 February 2011
Optimization of getting random rows out of a PostgreSQL in Django 23 February 2011
Related by Text:
crontabber now supports locking, both high- and low-level 04 March 2017
How do log ALL PostgreSQL SQL happening 20 July 2015
Select all relations in PostgreSQL 10 December 2015
C++ templates or not 18 February 2004
Connecting with psycopg2 without a username and password 24 February 2011