Tags: postgresql

Sort by: Date / Title /

  1. 2 years ago by xarkam
    uninstall Postgres 9.4,
    install 9.3,
    backup the database using pg_dumpall > backup.sql,
    uninstall Postgres 9.3,
    install Postgres 9.4,
    restore the databases using psql -d postgres -f backup.sql
    Paste this in your website: <script type="text/javascript" src="http://www.posteet.com/embed/2231"></script>
  2. 9 years ago by zeus
    PostgreSQL
    1. SELECT a.attnum, a.attname, case contype when 'p' then 'pk'
    2. else NULL end
    3. FROM pg_attribute a LEFT JOIN pg_constraint c ON
    4. (a.attnum = ANY(c.conkey) AND a.attrelid = c.conrelid)
    5. WHERE a.attrelid = 'public.table'::regclass AND a.attnum > 0  ;
    Paste this in your website: <script type="text/javascript" src="http://www.posteet.com/embed/596"></script>

First / Previous / Next / Last / Page 1 of 1 (2 posteets)