By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,852 Members | 2,200 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,852 IT Pros & Developers. It's quick & easy.

some question about column constraints

P: n/a
hi,
I work on a tool that generates a creat script for an existing table.
My problem is to find out if a column is a constraint.
For example, I have the following creat script

create table abc(
xyz serial primary key
)

The metadata say that xyz is an int4 and not nullable.
Where I can recognize that it is a serial primary key?
Is it true that xyz always - if it is a serial primary key - will be
stored as a sequence like abc_xyz_seq?
how will others column constraints (check, unique) be stored?

Thanks,
Bjoern
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Bjoern Schmidt writes:
I work on a tool that generates a creat script for an existing table.
My problem is to find out if a column is a constraint.


Look at how pg_dump does it. Or use pg_dump in the first place. What
functionlity does pg_dump lack for your task?

--
Peter Eisentraut pe*****@gmx.net
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.