Posts by leo Castro • 11 points

• 0

  votes

  1

  answer

  124

  views

  Q: Return the name instead of the ID in a Rails relationship

  I have two related tables in Rails, pessoa and cidade. On the table pessoa have the field cidade_id. How to do, for example, p = Pessoa.find(1) and in place of p.cidade_id already return the name of…

  ruby-on-rails ruby active-record

  asked 4 years, 10 months ago leo Castro 11

• 1

  votes

  1

  answer

  330

  views

  Q: Script to change table names in the Postgresql database

  I have this script: SELECT n.nspname AS schema_name, c.relname AS table_name, c.reltuples::int AS num_reg FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace LEFT JOIN pg_tablespace t…

  sql postgresql plpgsql

  asked 5 years, 9 months ago leo Castro 11