Re: PostgreSQL Syntax questions

On Thu, 12 Jun 2008, krishtpt wrote:

> 1. I am trying to disable constraints from a particular table in postgresql.
> But I couldn't get the alter command for the same.

The documentation is generally pretty good, if you know what you're
looking for. At what point in reading

http://www.postgresql.org/docs/8.3/interactive/sql-altertable.html

do you get confused?

> 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?

In psql, you can issue a command like:

\d <tablename>

...which will give you all the columns, their types, any indices, foreign
keys, triggers, etc. for <tablename>. This sounds like what you're looking
for?

> 4. I also would like to know how can I execute an sql file from windows
> command prompt in postgresql.

Again, psql is probably your friend. I'm not familiar with windows, but I
believe it allows redirection in the command prompt. In unix, you would:

psql <connection args> < file.sql

... and everything in file.sql would be executed as if you had typed it in
yourself.