Search Postgresql Archives

PostgreSQL Syntax questions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
-- 
View this message in context: http://www.nabble.com/PostgreSQL-Syntax-questions-tp17802013p17802013.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux