Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2008
    Posts
    1

    Unanswered: PostgreSQL Syntax questions

    Hi There,

    I am new to Postgresql. I have few questions regarding the sql syntax in Postgresql.
    1. I am trying to disable constraints from a particular table in postgresql. But I couldn't get the alter command for the same.
    2. I am trying to fetch all the constraints from a specific table using a select query. I am using 'select * from pg_constraint'. If I execute this query I am able to get all the constraints from all the tables. But I couldn't find which constraint is for what table. How can I get this data.
    3. I am also trying to fetch all the triggers for a specific table using a select query. How can I get this data?
    4. I also would like to know how can I execute an sql file from windows command prompt in postgresql.

    Please help me with these details.

    Thanks
    Krish

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    1. I am trying to disable constraints from a particular table in postgresql. But I couldn't get the alter command for the same.

    You cannot disable it. You have to either drop it, or declare it as "deferrable" so it is evaluated when you commit your data.

    2. I am trying to fetch all the constraints from a specific table using a select query. I am using 'select * from pg_constraint'. If I execute this query I am able to get all the constraints from all the tables. But I couldn't find which constraint is for what table. How can I get this data.
    http://www.postgresql.org/docs/8.3/s...ble-usage.html
    http://www.postgresql.org/docs/8.3/s...nstraints.html
    http://www.postgresql.org/docs/8.3/s...nstraints.html

    3. I am also trying to fetch all the triggers for a specific table using a select query. How can I get this data?
    http://www.postgresql.org/docs/8.3/s...-triggers.html

    4. I also would like to know how can I execute an sql file from windows command prompt in postgresql.
    http://www.postgresql.org/docs/curre.../app-psql.html

  3. #3
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Also, refer to the Information_Schema
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

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