| From: | Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com> |
|---|---|
| To: | 066ce286(at)free(dot)fr |
| Cc: | Mukesh Rajpurohit <vivasvan1902(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Oracle error log table equivalent in postgresql |
| Date: | 2021-08-06 12:30:12 |
| Message-ID: | CAM+6J973OY3B+0CiW45b_M2sv8th_Zp2CkTwsdyFtim_LGoFmA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Fri, Aug 6, 2021, 5:53 PM <066ce286(at)free(dot)fr> wrote:
> > Hi all,
> > I am porting oracle procedures into postgresql code and some oracle
> > procedure contain error log table and save exception code. I could
> > not find any equivalent of it in postgresql.
> >
> >
> > Please help if any pointer or lead to its solution.
>
If I understand correctly, you want to log exceptions to a table, or
assume it is logged to some system table.
I am not sure if there is inbuilt setup that logs the exceptions or any
messages to some table.
Everything gets logged to logfile based on how logging is configured.
There are ways where you can enable csv logging to file and use file_fdw to
make it queryable via sql query.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mukesh Rajpurohit | 2021-08-06 12:30:45 | Re: Oracle error log table equivalent in postgresql |
| Previous Message | 066ce286 | 2021-08-06 12:22:52 | Re: Oracle error log table equivalent in postgresql |