RE: Data Types

\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