Horton

RE: Data Types

WOLF, PATRICK <patrick.wolf@aerojet.com>

View thread View on postgr.es
From: patrick.wolf@Aerojet.com (WOLF, PATRICK)
To: "'syed asghar'" <abemail1@yahoo.co.uk>, pgsql-novice@postgresql.org
Date: 2000-07-27T15:18:29Z
Lists: pgsql-novice 
\d tablename

Pat

		-----Original Message-----
		From:	syed asghar [mailto:abemail1@yahoo.co.uk]
		Sent:	Thursday, July 27, 2000 9:09 AM
		To:	pgsql-novice@postgresql.org
		Subject:	[NOVICE] Data Types

		Hello again,

		Thanks everyone for your help re: backup.

		If you are given a database and you need info about eg
		what field types were specified - How do you do this?

		I know you can list all tables with \d command and the
		table contents with a select.. but I can't seem to
		figure out how to find out what data types are used.

		____________________________________________________________
		Do You Yahoo!?
		Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
		or your free @yahoo.ie address at http://mail.yahoo.ie