Hi,
We are using Postgres 8.1.0
Question No 1:
=
There are lots of system tables that are available in postgres. For
example pg_tables will have all the information about the tables that are
present in a given schema. pg_views will have all the information about the
views for
Am Mittwoch, 5. Oktober 2005 21:29 schrieb Adriano Gaspar:
I´m interesting in learning Postgre because I´m working with it now, if you
can, i want to know wich are the system tables, and in wich of them can I
find a table with all of the tables, and constrants.
I don't know what Postgre is
I´m interesting in learning Postgre because I´m working with it now, if you
can, i want to know wich are the system tables, and in wich of them can I find
a table with all of the tables, and constrants.
Thanks,
Adriano Gaspar.
No iBest, suas horas navegadas valem pontos que podem ser trocados
Andrzej Schulz writes:
Hi, I would Like to get information abort tables existing In PostgreSQL
via PHP. I would like to know the names, their description and of
course how they are build.
http://www.postgresql.org/docs/7.3/static/catalogs.html
--
Peter Eisentraut [EMAIL PROTECTED]
Hi, I would Like to get
information abort tables existing In PostgreSQL via? PHP. I would like to know the names,
their description and of course how they are build.
I Am not quite sure how to
get this on the Web Site, in PG I can use
?
\d table_name, but
it doesnt work here
Can
well in unix man psql command line options -E shows the queries that are
generated by the \d or other sudo commands
reading a 10 point font on a 1600x1280 screen sucks, please text only to
mailing lists
--
Arno Karner aka Behind the Muffs
West 7th St., St. Paul aka smell, Minn
Hi, I would Like to get
information abort tables existing In PostgreSQL via? PHP. I would like
to know the names, their description and of course how they are build.
I Am
not quite sure how to get this on the Web Site, in PG I can use
?
\d table_name,
but it doesnt work here
Can
pgadmin tables are not system tables; they're just used by the pgadmin tool.
I believe there is an option to clean them out somewhere in pgadmin.
System tables views start with pg_
- Stuart
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, October
Hi
when I give \d command at psql prompt, it is displaying all the tables
including
pgadmin_tables etc in development database. But when I give the same
command in production datbase , it is just showing the table that have
been created, not any system tables( pgadmin tables or views).
why it is