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.
--
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
