Fully qualified table name in Postgres

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