Postgres Pro
Downloads
Home   >   mailing lists

Thread: Data Types

Data Types

From
syed asghar
Date:
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

RE: Data Types

From
patrick.wolf@Aerojet.com (WOLF, PATRICK)
Date:
\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