John Browne <jkbrowne@xxxxxxxxx> writes: > I was curious if there was a way to get the DDL for a particular table > from the psql client console? No. Try pg_dump -s -t tablename dbname regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match