Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Describe objects in SQL Developer for PostgreSQL

d21d5131-5fc1-401d-8121-99c2ed7b6255Aug 25 2017 — edited Sep 19 2017

Hi All,

I am using sql developer 4.1.3.20 with Enterprise DB (PostgreSQL). May I know how to describe a table/function for PostgreSQL, generally I use to use Shift+F4/(Right click, Popup Describe) for Oracle DB.  Help to let me know how to describe objects for PostgreSQL using sql developer.

Currently I am using to get the table columns from ALL_TAB_COLUMNS or by expanding from the left side navigation pane.

But looking for popup window type description.

Thanks,

Anil

Comments

800381
Assuming you're using Studio 12.3, the compile-time options are one of "-xcode=pic13" or "-xcode=pic32".

The deprecated options are "-Kpic" and "-KPIC".
user458823
Thank you, that was indeed the fix. Here is a summary I sent to the mod_perl mailing list:

We could successfully build 64 bit apache with the configuration options so kindly shared by John D. Groenveld, also, in order to build mod_perl on 64 bit perl we had to recompile perl 64 bit, these are the flags we used:
./Configure -ders -Dcc=cc -Ud_sigsetjmp -Uinstallusrbinperl -Ulocincpth= -Uloclibpth= -Duse64bitint -Duse64bitall -Ud_strerror_r -Ud_signbit -Duselargefiles -Dprefix=/usr/perl10/5.18.0 -Accflags="-xcode=pic32"

The noteworthy flags in above ./Configure are -Accflags="-xcode=pic32" in ./Configure the "-Accflags=" passes the flags you want to the C compiler, in our case we wanted the -xcode=x32 flag to be passed to the C compiler(solaris studio compiler) because of the error message we were getting:
"symbol PL_check: relocations based on the ABS44 coding model can not be used in building a shared object"
So to build for "shared object" support, perl 64 bit had to be recompiled with the -xcode=pic32 flag

Building mod_perl was then seamless, perl Makefile.PL (NOTE: the perl is teh perl which was built with above arguments.
make, make install.


It is important to use the SAME COMPILER for everything. We are using Solaris Studio compiler, which, John D. Grovenfeld also used. We needed DBD::mysql to talk to the MYSql database, now Mysql was installed on Solaris 10 via pkgadd and is a 64 bit application. Needless to say it is safe to assume that Oracle built it using the Solaris Studio compiler......

DBD::mysql was built using MCPAN shell.....

Hope this helps someone in the future.......

Thanks to John D. Groenveld, The other resources online, and to my boss...
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 17 2017
Added on Aug 25 2017
#sql-developer
2 comments
1,142 views