1 - \d table give you the definition of your table "table"
2 - select * from pg_user; give you the name of users;
Williams, Quinton L wrote:
>Hello, I'm new to using PostgreSQL as a backend for NetReg (www.netreg.org
><http://www.netreg.org/> ).
>I have some questions on getting started. I have installed the database on
>a Linux box.
>
>1. How do you list the definitions of the tables you have created in a
>database?
>2. How do you list the users in a database?
>
>I know I will probably have some user authentication questions once this
>NetReg program tries to access the database with the user I created.
>Quinton Williams
>Telecommunications Analyst
>University of Houston
>(832) 842-4680
>
>
>
>
>
--
Bruno LEVEQUE
System Engineer
SARL NET6D
bruno.leveque@net6d.com
http://www.net6d.com