Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010
    Posts
    1

    Question Unanswered: inserts on views(Postgres)

    Hi,
    In the view we are showing whole address as one record(column),If we insert or update view how do we insert into the address table
    as seperate columns.

  2. #2
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    This is a Bad Idea (tm). You can add rewrite rules but you don't want to parse out address, city, state, zip from one big text field.

    PostgreSQL: Documentation: Manuals: PostgreSQL 8.2: Rules on INSERT, UPDATE, and DELETE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •