Fully qualified table name in Postgres

1820
2
06-11-2010 01:05 AM
StefanOffermann
Occasional Contributor II
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
0 Kudos
2 Replies
TITTIT
by
New Contributor
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
0 Kudos
StefanOffermann
Occasional Contributor II
Thanks for your answer, I figured it out already (I had some time since november 2010 *g*)
0 Kudos