<html><body><html><head></head><body><div>
<meta charset="utf-8">
<div id="compose-body-wrapper" dir="auto"><div dir="auto">A fully specified record in geometry_columns can be created even if no data exists in the table.</div><div dir="auto"><br></div><div dir="auto">TypeMod is your friend!</div><div dir="auto"><br></div><div dir="auto"><div dir="auto">drop table if exists foo ;</div><div dir="auto">select * from geometry_columns where f_table_name = 'foo';</div><div dir="auto">create table foo ( id integer, geom geometry);</div><div dir="auto">select * from geometry_columns where f_table_name = 'foo';</div><div dir="auto">drop table foo ;</div><div dir="auto">create table foo ( id integer, geom geometry(LineString,28356));</div><div dir="auto">select * from geometry_columns where f_table_name = 'foo';</div><div><br></div><div><br></div></div><div dir="auto"><br></div><div dir="auto" id="tmjah_g_1299">Get <a href="https://bluemail.me/download" target="_blank">BlueMail</a> for Windows</div><br></div><div class="replyHeader" dir="auto">Simon Greener wrote:</div><br><br><div><blockquote cite="mid:85f4f959-419e-4a15-864e-edddf2090a0d@spatialdbadvisor.com" type="cite" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif}
a:link, span.x_MsoHyperlink
{color:#0563C1;
text-decoration:underline}
a:visited, span.x_MsoHyperlinkFollowed
{color:#954F72;
text-decoration:underline}
p
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif}
span.x_EmailStyle18
{font-family:"Calibri",sans-serif;
color:#1F497D}
.x_MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.x_WordSection1
{}
-->
</style><div dir="auto">Can you force the creation of a record in geometry_colums?<br><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->Get <!-- tmjah_g_1299e --><a href="http://www.bluemail.me/r?b=15860"><!-- tmjah_g_1299s -->BlueMail for Android<!-- tmjah_g_1299e --></a><!-- tmjah_g_1299s --> <!-- tmjah_g_1299e --></div>
<div class="gmail_quote">On 1 Jul 2020, at 09:24, imran hussain <<a href="mailto:imranhcet@hotmail.com" target="_blank">imranhcet@hotmail.com</a>> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div style="color: rgb(33, 33, 33); background-color: rgb(255, 255, 255); text-align: left;" dir="auto">
I am trying to connect from Alteryx using psqlodbc driver. The geometry_columns table is not populated for the table I am trying to access, since it's got no spatial data.</div>
<div style="color: rgb(33, 33, 33); background-color: rgb(255, 255, 255); text-align: left;" dir="auto">
<br>
</div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> postgis-users <postgis-users-bounces@lists.osgeo.org> on behalf of Simon Greener <simon@spatialdbadvisor.com><br>
<b>Sent:</b> Tuesday, June 30, 2020 4:46:40 PM<br>
<b>To:</b> PostGIS Users Discussion <postgis-users@lists.osgeo.org><br>
<b>Subject:</b> Re: [postgis-users] Postgis extension</font>
<div> </div>
</div>
<div lang="EN-US" link="#0563C1" vlink="#954F72" style="zoom:0%">
<div dir="auto">Is geometry_columns fully populated?<br>
<br>
<br>
<br>
</div>
<div dir="auto">Get <a href="http://www.bluemail.me/r?b=15860">BlueMail for Android</a>
</div>
<div class="x_gmail_quote">On 1 Jul 2020, at 07:19, Regina Obe <<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>> wrote:
<blockquote class="x_gmail_quote" style="margin:0pt 0pt 0pt 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div class="x_WordSection1">
<p class="x_MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">Which system are you connecting from?  Sounds like whatever system you are using is designed to work with spatial tables. Like as I recall I think ArcMap
uses PostgreSQL ODBC driver.</span></p>
<p></p>
<p></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D"></span></p>
<p> </p>
<p></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">There isn’t any reason otherwise why you should be having issue connecting to a non-spatial table.  I connect via SQL Server and MS Access all the time even
when I have spatial tables in my database.  There isn’t even any reason why a system would check geometry_columns unless it’s designed to work with spatial data.</span></p>
<p></p>
<p></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D"></span></p>
<p> </p>
<p></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">Hope that helps,</span></p>
<p></p>
<p></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">Regina</span></p>
<p></p>
<p></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D"></span></p>
<p> </p>
<p></p>
<div style="border:none; border-left:solid blue 1.5pt; padding:0in 0in 0in 4.0pt">
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_MsoNormal"><b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif"> postgis-users [mailto:postgis-users-bounces@lists.osgeo.org]
<b>On Behalf Of </b>imran hussain<br>
<b>Sent:</b> Tuesday, June 30, 2020 3:47 PM<br>
<b>To:</b> 'PostGIS Users Discussion' <postgis-users@lists.osgeo.org><br>
<b>Subject:</b> [postgis-users] Postgis extension</span></p>
<p></p>
<p></p>
</div>
</div>
<p class="x_MsoNormal"></p>
<p> </p>
<div>
<p class="x_MsoNormal"><span style="font-family:"Calibri",sans-serif; color:black">Hi,</span></p>
<p></p>
<p></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-family:"Calibri",sans-serif; color:black"></span></p>
<p> </p>
<p></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-family:"Calibri",sans-serif; color:black">I am trying to access the Postgres DB using ODBC driver. I have Postgis extension installed on my DB and when trying to query the non-spatial tables from the tool, I keep getting
the error "no records returned from GEOMETRY_COLUMNS for this table". Is there any environment variable that would let the ODBC know that its a non spatial table and avoid looking into GEOMETRY_COLUMNS view ?</span></p>
<p></p>
<p></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-family:"Calibri",sans-serif; color:black"></span></p>
<p> </p>
<p></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-family:"Calibri",sans-serif; color:black">Thanks,</span></p>
<p></p>
<p></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-family:"Calibri",sans-serif; color:black">Imran Hussain</span></p>
<p></p>
<p></p>
</div>
</div>
</div>
<pre class="x_blue"><hr><br>postgis-users mailing list<br>postgis-users@lists.osgeo.org<br><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
</div>
</div>
<pre class="blue"><hr><br>postgis-users mailing list<br>postgis-users@lists.osgeo.org<br><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre></blockquote></div></blockquote></div>
</div></body></html></body></html>