Hello jack,
To check if a table exists you could use:
select tablename from pg_tables;
For instance:
dhcp=# select count(*) from pg_tables where tablename='dhcp_subnet';
count
-------
1
(1 row)
dhcp=# select count(*) from pg_tables where tablename='dhcp_subnetaa';
count
-------
0
(1 row)
To see the system tables use \dS
The second I don't really know what you would like to see.
Perhaps a trigger could do this after the insert/update/delete ?
Best regards,
Roelof
> -----Original Message-----
> From: datactrl [SMTP:[EMAIL PROTECTED]]
> Sent: 15 March 2001 12:04
> To: [EMAIL PROTECTED]
> Subject: [SQL] Some questions about PLpgSql
>
> Hi, all
>
> By using 'PLpgsql', is that possible to
>
> 1) check if a specific table exists?
> 2) check if an INSERT/UPDATE/ DELETE has done successfully?
>
>
> Is there some more documents or samples for PLpgsql except USER GUIDE and
> PostgreSQL Introduction & concept?
>
> THANK YOU
>
> JACK
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
