topic Re: Fully qualified table name in Postgres in Data Management Questions

Fully qualified table name in Postgres

StefanOffermann — Fri, 11 Jun 2010 08:05:56 GMT

Can anyone give me a quick hint on how table names are fully qualified using a PostgreSQL database? I am not sure if it is
<dbname>.<owner>.<tablename>
or
<schema>.<owner>.<tablename>

I want to use it in a configurable python script, eg

CopyFeatures "C:\local\Shape_1_1.shp" "Database Connections\pg.sde\<?>.<?>.Test_1_1" # 0 0 0

I am using SDE 9.3.1

Best regards, Stefan

Re: Fully qualified table name in Postgres

TITTIT — Mon, 18 Apr 2011 06:56:03 GMT

Maybe to late, but:

The schema is:

<dbname>.<schema>.<tablename>
whereby <schema> is the same as <user>

(there hasn't to be a arcsde user without a same named schema)

greetz

Re: Fully qualified table name in Postgres

StefanOffermann — Mon, 18 Apr 2011 08:28:44 GMT

Thanks for your answer, I figured it out already (I had some time since november 2010 *g*)